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 Everyone,
I have been struggling to find a solution to finding that last time my Product Rev changed. The goal is to have my Power BI show if the revision changed and so far all my attempts have not worked.
Here are the basic columns which have my details.
Version | Product | Prod Rev | Latest Rev Date |
1/1/2023 | Red | Rev 1 | 1/1/2023 |
1/1/2023 | Orange | Rev 2 | 1/1/2023 |
1/1/2023 | Black | Rev 1 | 1/1/2023 |
1/8/2023 | Red | Rev 2 | 1/8/2023 |
1/15/2023 | Red | Rev 2 | 1/8/2023 |
1/15/2023 | Orange | Rev 2 | 1/1/2023 |
1/22/2023 | Orange | Rev 3 | 1/22/2023 |
2/2/2023 | Orange | Rev 3 | 1/22/2023 |
2/2/2023 | Black | Rev 1 | 1/1/2023 |
2/9/2023 | Black | Rev 2 | 2/9/2023 |
2/16/2023 | Black | Rev 2 | 2/9/2023 |
2/16/2023 | Red | Rev 3 | 2/16/2023 |
2/23/2023 | Red | Rev 3 | 2/16/2023 |
2/23/2023 | Black | Rev 2 | 2/9/2023 |
3/2/2023 | Black | Rev 3 | 3/2/2023 |
3/9/2023 | Black | Rev 3 | 3/2/2023 |
You can see in the table the Latest Rev Date stays with the Product Versions (report dates) till the Prod Rev changes again.
I think a calculated column makes the most sense because my dataset it several million rows and I am worried about load time, but I could work with a measure probably.
Thanks!
Matt
Solved! Go to Solution.
Hi @Anonymous
in your example you are showing the minimum version for the same Product/Prod Rev. but you asking for the last? Please clarify. Otherwise, to produce the same results as per the provided sample and results you may try a calculated column
Latest Rev Date =
CALCULATE ( MIN ( 'Table'[Version] ), ALLEXCEPT ( 'Table', 'Table'[Product], 'Table'[Prod Rev] ) )
Hi @tamerj1 ,
You got it perfect! Sorry about the mix up in min and max. Min was what I was looking for.
Thank you so much!
Hi @tamerj1 ,
You got it perfect! Sorry about the mix up in min and max. Min was what I was looking for.
Thank you so much!
Hi @Anonymous
in your example you are showing the minimum version for the same Product/Prod Rev. but you asking for the last? Please clarify. Otherwise, to produce the same results as per the provided sample and results you may try a calculated column
Latest Rev Date =
CALCULATE ( MIN ( 'Table'[Version] ), ALLEXCEPT ( 'Table', 'Table'[Product], 'Table'[Prod Rev] ) )
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |