Forum Discussion
Last Record Value by Condition
Hi dharmendars007 ,
thank you so much.
For each COD the value is correct, but the total is wrong, maybe it get the MAX
have you other idea?
It might be useful create a table like and then make SUM(LastValue) ?
DATA COD TYPE AMOUNT LAST VALUE 2024-11-20 A F 0 2024-11-20 A G 15 2024-10-02 A F 10 10 2024-10-03 B G 5 2024-10-01 B F 1 1
Hi dharmendars007 ,
thank you so much.
For each COD the value is correct, but the total is wrong, maybe it get the MAX
have you other idea?
It might be useful create a table like and then make SUM(LastValue) ?
| DATA | COD | TYPE | AMOUNT | LAST VALUE |
| 2024-11-20 | A | F | 0 | |
| 2024-11-20 | A | G | 15 | |
| 2024-10-02 | A | F | 10 | 10 |
| 2024-10-03 | B | G | 5 | |
| 2024-10-01 | B | F | 1 | 1 |
Memorable MemberHello inversia ,
To Display the Total: If you want to display the total of the "LAST VALUE" column (e.g., TOTAL 11), you can create another measure:
TOTAL LAST VALUE =
SUMX(VALUES('DATA'[COD]), [LAST VALUE])
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
It's work. Awesome. Thank you so much