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.
I have the below data.
Order | Product | Order Date |
1 | P1 | 9-Oct |
1 | P2 | 10-Oct |
1 | P3 | 8-Oct |
2 | P4 | 9-Oct |
2 | P5 | 8-Oct |
I want to show the Product which is present in the row where the date is latest.
Result
Order | Product | Order Date |
1 | P2 | 10-Oct |
2 | P4 | 9-Oct |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you @Ashish_Mathur ..the solution works fine..
We have to make one measure for farthest date.
and another one for the product column to select the product of the farthest date.
You are welcome.
Hi,
It works just fine. Please try agin.
@Ashish_Mathur i got it now..seems to be a VPN problem at my side..I need to install the latest version of PBI..so it will be a while I will get back to you.
Create a column
_Selected =IF('table'[Order Date] = CALCULATE(MAX('table'[Order Date]), ALLEXCEPT('table','table'[Order])),1,0)
And while displying the result filter the result on _selected to have 1.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@pranit828 we do not want to filter any data here..we just want to consider latest value of order date and show that product in subtotals.
The code will do as mentioned in the intial ask you have posted.
Maybe elaborate your ask more to get the exact solution.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Your question is not clear
in case of P1 also of 9 oct then how to categorise only P4 as 9 Oct. any logic behind it?
Proud to be a Super User!
@VijayP I have listed only the date part here..the actual data contains time part also.
if we have same timestamp , it should take alphanumeric ascending order of Product column.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |