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.
Hi,
I need help on how can I get the value from "Type" column based from max Purchased Date per Product Number and ProductLineNum. For example, for Product Number 5100, the max Purchased Date is 10/25/2019 so it should return the value of "Major equipment".
Expected output:
I'm trying VAR and RETURN formula but I could not get it right.
Thank you in advance
Solved! Go to Solution.
Hello there @summer18 ! Try this:
Latest Type =
CALCULATE (
MAX ( Table[Type] ),
FILTER (
'Table',
'Table'[Purchased Date]
= CALCULATE (
MAX ( 'Table'[Purchased Date] ),
FILTER ( Table, 'Table'[Product Number] = EARLIER ( 'Table'[Product Number] ) )
)
&& [Product Number] = EARLIER ( [Product Number] )
)
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Hello there @summer18 ! Try this:
Latest Type =
CALCULATE (
MAX ( Table[Type] ),
FILTER (
'Table',
'Table'[Purchased Date]
= CALCULATE (
MAX ( 'Table'[Purchased Date] ),
FILTER ( Table, 'Table'[Product Number] = EARLIER ( 'Table'[Product Number] ) )
)
&& [Product Number] = EARLIER ( [Product Number] )
)
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |