Forum Discussion
Help with DAX
In my Cube table I have a table showing employee and the number of hours they have submitted late in their timesheets by week. For example, if I filter for all the weeks in Feb 2023 I can see tha...
Yes, that will give me answer by week. Example for employ 123,
Week 1 = Not Late
Week 2 = Not Late
Week 3 = Not Late
Week 4= Late
If I select all 4 weeks I want the DAX to show them as Late.
Basically work want to select a bunch of weeks and see who has not filled out their timesheets on time. Imagine there are 100 employees they don't want to see the same 100 employees in the table as both Late and Not Late.. they;re either Late or On time for the period selected