Forum Discussion
AndyDD_UK
Helper III
Helper IIIHelp 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...
AndyDD_UKSorry don't understand your question...unless this helps ?
Employee = text
Week = date
Hours = decimal to one place
Is that what you mean ?
- AndyDD_UK
Ah, sorry....there is a column that says 'Late_hours'...if the value is 0 then they are not late, if the value is over zero, then they are late.
So the challenge is rolling this up...for the 4 weeks in Feb 2023 they may have zero late hours for 3 weeks and more than zero in one of the weeks. If the Power BI report I want them to appear only as 'Late' if I select all 4 weeks. Thanks for your help on this.