Forum Discussion
Solved
Count Serial if Outgoing Reps Time is between Sign In Start and Finish Time
Hi, I have four tables Outgoing Reps Sign In Calendar Officer Calendar and Officer are dimension tables and Outgoing Reps and Officer are linked to Calendar and Officer table. I am look...
Depends on your entire model and how you use it, perhaps its better to make preparations with Power Query. In attached file that's Outgoing Reps time slots.
With it we have quite simple measures, PivotTable looks like
I have Outgoing Reps table linked to Officer and Calendar Table and Sign In linked to Officer and Calendar but I am getting this message.
I hop the attached spreadsheet will give more information.
Thank you
Depends on your entire model and how you use it, perhaps its better to make preparations with Power Query. In attached file that's Outgoing Reps time slots.
With it we have quite simple measures, PivotTable looks like
- Thank you so much and much appreciated for giving your time on this. This is extremely helpful
Both solutions working great.
Thanks
Best regards,
mouzzampkmouzzampk , you are welcome