Forum Discussion
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 customers this Card will change to the correct date. Great!
But I cannot drag this same activity date field into a table visualization and choose "latest" -- it just duplicates every action record.
I've been trying to create a measure, thinking I need the GROUPBY and LASTDATE operators?
Marc
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.
4 Replies
- tackytechtom
Most Valuable Professional
Hi PCHMarc67 ,
How about something like this :
MeasureGroupBy = CALCULATE ( MAX ( 'YourTableName'[Date] ), ALLEXCEPT ( YourTableName, YourTableName[Customer] ) )
Let me know, if this helps 🙂/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/ Let me Clarify... this is what the source table looks like. lots of rows repeating my people. So I want to create a measure that would group by Constituent ID then return the last Action Date (10/8/2021) thx
- v-chenwuz-msft
Community Support
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.
This is perfect! thank you
