I am trying to list the most recent value of a type.
date type value1-1-2016 RED 2102-1-2016 RED 17010-1-2016 RED 1901-1-2016 GREEN 40015-1-2016 GREEN 56016-1-2016 GREEN 5002-2-2016 YELLOW 18010-2-2016 YELLOW 20018-2-2016 YELLOW 240
The only result that I want to have in a calculate table is:
10-1-2016 RED 19016-1-2016 GREEN 50018-2-2016 YELLOW 240
But every time, i get the sum of all three line items (for yellow: 180+200+240, instead of 240).
I manage to select the lastdate, with LASTDATE(date), but i get always the summed (180+200+240) value.
What about to create a calculated table, that has only the last values in it per type? Then is will not sum the different values for the dates as these are not in the table.
Go to Solution.
A give you a solution but not using calculate table;
1: Create a measure:
ALLEXCEPT ( Table1, Table1[Type] ),
CALCULATE ( VALUES ( Table1[Date] ) ),
2, Use this measure as Visual Level filters
View solution in original post
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.