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  thanks for your reply... Apart from using Employee field in stead of resource Key (which is effectively the unique employee ID) your measure is probably the same as mine...  i think maybe you require some additional information... so the Month is being pulled into the visual from the linked Date Dimension table, the join is from snapshot date stamp to the data.. does that help?

 

Cheers

 

Andy

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