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.
I'm trying to display the most recent value in a card but cant seem to get it to work correctly.
I have different individuals who have had their weight, skinfolds etc measured on different days and I want the cards to display the most recent scores for weight, skinfolds etc.
For example if I selected Player 1 his cards would display:
Weight 124.54
Skinfolds 79.21
Name. Date Tested. Weight. Skinfolds
Player 1. 12/3/2020. 123. 75.32
Player 2. 24/4/2020. 98.67 43.21
Player 1. 20/4/2020. 124.54. -
Player 2. 15/1/2020. 96.90 45.00
Player 1. 1/5/2020. - 79.21
Solved! Go to Solution.
@jamieham , Try measure like
last Weight = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Weight]))
last Skinfolds = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Skinfolds]))
@jamieham , Try measure like
last Weight = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Weight]))
last Skinfolds = LASTNONBLANKVALUE(Table[Date Tested], max(Table[Skinfolds]))
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 |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |