Forum Discussion

andybamber's avatar
andybamber
Icon for Helper III rankHelper III
5 years ago

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(...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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?

  • andybamber's avatar
    andybamber
    Icon for Helper III rankHelper III
    5 years ago

    Hi There!

     

    Dax would be the preferred option, but i'm open to a power query solution..

     

    Cheers

     

    Andy