Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
For example, I have that data:
FruitPriceDate
Banana | 10 | 11/01/2018 |
Banana | 12 | 11/01/2018 |
Banana | 11 | 12/01/2018 |
Banana | 15 | 12/01/2018 |
I wish to retrieve the last value based on date
Instead of SUM data for 11/01 I wish to retrieve Price: 12
And for 12/01 retrieve Price: 15
Thank you.
Solved! Go to Solution.
Assuming that value you want would be the max if more than 1 value was on the same day:
Last Price = CALCULATE( MAX(Table2[Price]), LASTDATE(Table2[Date] ))
Assuming that value you want would be the max if more than 1 value was on the same day:
Last Price = CALCULATE( MAX(Table2[Price]), LASTDATE(Table2[Date] ))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |