Forum Discussion
Dax Measure - Lastdate
Hello All! I have a file of weekly data snapshots. The file has a snapshot date stamp I have a measure: headcount_Max_Wk = CALCULATE(DISTINCTCOUNT(SNAP_DWH_RES_RESOURCE[resource_key]),LASTDATE(...
For each Employee and Month Name you want to find the latest Day of the month. Once you have that you can then lookup the Job role for that user for that date.
Do you need to do this in DAX or is Power Query an option too?
Hi There!
Dax would be the preferred option, but i'm open to a power query solution..
Cheers
Andy