Forum Discussion

mouzzampk's avatar
mouzzampk
Copper Contributor
Nov 17, 2023

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...
Excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 18, 2023

    mouzzampk 

    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

mouzzampk's avatar
mouzzampk
Copper Contributor
Nov 18, 2023
Thank you so much and much appreciated for giving your time on this. This is extremely helpful

Both solutions working great.

Thanks

Best regards,
mouzzampk

Resources