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...
Sorry...compliance is whether they are late or not...all the data required is in the one table called EMPL in the Cube...
In EMPL you have week....and in DimDate Table there is week and month
Thanks again
AndyDD_UK
The compliance column must not be in the matrix as calculated columns are not dynamic, rather they're calculated once when you refresh the pbix file.
The very first DAX I shared with you is a measure not a calculated column. And I'm pretty sure that once placed in the values of the matrix, it should work just fine at both week level and month level.
Compliance Mesure =
IF ( SUM ( 'EMPL'[Late_hours] ) = 0, "Not Late", "Late" )