Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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.
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
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
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |