Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have a customer record, where a column indicates the current status of the negotiations. For each status update, new data is generated as shown below:
Name Status Date
Carlos Preliminary call 02-03-2021
Franz Contact 01-03-2021
Carlos Adjusting details 02-03-2021
Franz Reunion final 04-03-2021
Franz Contract signed 05-03-2021
I what I need to show you what is the most up-to-date state of negotiations to take action on this, below is an example regarding the above data (it should work for the n customers I have):
Name Status Date
Carlos Adjusting details 02-03-2021
Franz Contract signed 05-03-2021
Thanks a lot!
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Since there is no unique value in the data, you need to create an index column in the query editor, which makes the problem much easier.
Then create a measure and apply it to visual level filter.
Measure 2 =
var latest= CALCULATE(MAX('Table'[Index]),ALLEXCEPT('Table (2)','Table (2)'[Name]))
return IF(MAX('Table (2)'[Index])=latest,1)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Since there is no unique value in the data, you need to create an index column in the query editor, which makes the problem much easier.
Then create a measure and apply it to visual level filter.
Measure 2 =
var latest= CALCULATE(MAX('Table'[Index]),ALLEXCEPT('Table (2)','Table (2)'[Name]))
return IF(MAX('Table (2)'[Index])=latest,1)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the answer, but following your advice I get the following error message and I don't see what the fault is.
@Syndicate_Admin , for date use Max and for status use this measure
Status =
VAR __id = MAX ('Table'[Name] )
VAR __date = CALCULATE ( MAX('Table'[Date] ), ALLSELECTED ('Table' ), 'Table'[Name] = __id )
CALCULATE ( max ('Table'[Status] ), VALUES ('Table'[Name] ),'Table'[Name] = __id,'Table'[Date] = __date )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |