How to present only the last updated value?

[Anonymous]

So, I have a list of costs that are updated once a month and I need to be able to present the latest value. As you can see in the attached image, I have 2 "groups". The first one should present only the most recent costs values and the other one should present all off the costs values through the different dates. How can I show only the most recent values in the first group and all of the values in the seconde one?

THANKS!

[selimovd · Accepted solution]

Hey @Anonymous ,

you should be able to solve that with the pattern for semi additive measures. An easy example would be:

Balance LastDate :=
CALCULATE (
    SUM ( Balances[Balance] ),
    LASTDATE ( 'Date'[Date] )
)

But check out the full article to get all the details about the semi additive measures:

Semi-additive calculations – DAX Patterns

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

I think it works, but I have to create a measure for all the different costs right?

Best Regards

[selimovd]

Hey @Anonymous ,

for everything that is semi-additive you need to create an own measure.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thanks a lot for your help @selimovd !!

It works!!

Best regards