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 have a table in DW that is updated every month.
how can I use DAX for summarizing "product a" for the most updated date?
date | product a | product b |
01/01/2018 | 69 | 500 |
01/01/2018 | 1669 | 5221 |
01/01/2018 | 0 | 128 |
01/01/2018 | 0 | 0 |
01/02/2018 | 0 | 129 |
01/02/2018 | 69 | 500 |
01/02/2018 | 1668 | 5220 |
01/02/2018 | 0 | 0 |
01/03/2018 | 1666 | 5222 |
01/03/2018 | 0 | 127 |
01/03/2018 | 69 | 497 |
01/03/2018 | 0 | 0 |
01/04/2018 | 1661 | 5221 |
01/04/2018 | 69 | 497 |
01/04/2018 | 0 | 127 |
01/04/2018 | 0 | 0 |
01/05/2018 | 1661 | 5221 |
01/05/2018 | 69 | 497 |
01/05/2018 | 0 | 127 |
01/05/2018 | 0 | 0 |
Solved! Go to Solution.
HI @chen_shany
I think this calculated measure will work for the data as you present it. I have attached a PBIX file that shows this and also a measure that works with Product B. However I recommend you pivot your data around so that Products are in rows and not columns.
Most Updated Product A = MAXX( FILTER( 'Table1', 'Table1'[product a]=MAX('Table1'[product a]) ), 'Table1'[date] )
HI @chen_shany
I think this calculated measure will work for the data as you present it. I have attached a PBIX file that shows this and also a measure that works with Product B. However I recommend you pivot your data around so that Products are in rows and not columns.
Most Updated Product A = MAXX( FILTER( 'Table1', 'Table1'[product a]=MAX('Table1'[product a]) ), 'Table1'[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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |