Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am trying to list the most recent value of a type.
date type value
1-1-2016 RED 210
2-1-2016 RED 170
10-1-2016 RED 190
1-1-2016 GREEN 400
15-1-2016 GREEN 560
16-1-2016 GREEN 500
2-2-2016 YELLOW 180
10-2-2016 YELLOW 200
18-2-2016 YELLOW 240
The only result that I want to have in a calculate table is:
10-1-2016 RED 190
16-1-2016 GREEN 500
18-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.
Any suggestions?
John
Solved! Go to Solution.
hi @JohnD2
A give you a solution but not using calculate table;
1: Create a measure:
RankDate = RANKX ( ALLEXCEPT ( Table1, Table1[Type] ), CALCULATE ( VALUES ( Table1[Date] ) ), , DESC, SKIP )
2, Use this measure as Visual Level filters
hi @JohnD2
A give you a solution but not using calculate table;
1: Create a measure:
RankDate = RANKX ( ALLEXCEPT ( Table1, Table1[Type] ), CALCULATE ( VALUES ( Table1[Date] ) ), , DESC, SKIP )
2, Use this measure as Visual Level filters
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
32 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |