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(...
andybamber's avatar
andybamber
Icon for Helper III rankHelper III
5 years ago

Anonymous its currently set as both....

Anonymous's avatar
Anonymous
Not applicable
5 years ago

andybamber  Can you please sample file with relevant data and kindly mask other columns.It will be great .

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

    Anonymous  I have a file for you, how do i send as it wont let me attach a PBIX into a message....

     

    Cheers

    Andy

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

    Anonymous  i should also have said regarding the PBIX that the right hand bar chart is correctm showing 8 for both months, but its the one on the left with the actual role where its not counting correctly... thanks