Forum Discussion

PCHMarc67's avatar
PCHMarc67
Frequent Visitor
4 years ago
Solved

Last Date based on ID grouping in Table Dax Measure

Hello!  New to BI and this forum I have a table with customer ID's and their last activity date.  I can drag this date field into a Card and set it to "latest" and by clicking on a visualization of ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi PCHMarc67 ,

     

    Maybe you can try this expression:

    Measure =
CALCULATE (
    MAX ( 'Table'[Action Date] ),
    'Table'[Constituent ID] = SELECTEDVALUE ( 'Table'[Constituent ID] )
)

    Then you need put the name field in the table firstly to group the table.

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi PCHMarc67 ,

 

Maybe you can try this expression:

Measure =
CALCULATE (
    MAX ( 'Table'[Action Date] ),
    'Table'[Constituent ID] = SELECTEDVALUE ( 'Table'[Constituent ID] )
)

Then you need put the name field in the table firstly to group the table.

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PCHMarc67's avatar
PCHMarc67
Frequent Visitor
4 years ago

This is perfect!  thank you