Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |