Forum Discussion

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

andybamber : It Will Work for that as well . you have to define BI Directional Relationship in between datetable and  your master table then it will work fine for you .



 

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

Anonymous its currently set as both....

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 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
      6 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
      6 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