How to get a value of the last date?

[Anonymous]

Hello, 

I have a database that has the following colunms: Product, Date and value. I need to get the value of the last date per product, to put in a card. How can I do this?

Best regards!

[amitchandak · Accepted solution]

@Anonymous , Refer my these two blogs

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

[v-yinliw-msft · Accepted solution]

Hi @Anonymous ,

You can try the following methods.

Here is my test table:

Measure:

Max date =

CALCULATE (

    MAX ( 'Product'[Date] ),

    FILTER ( 'Product', [Product] = SELECTEDVALUE ( 'Product'[Product] ) )

)

Max date value =

CALCULATE (

    MAX ( 'Product'[Value] ),

    FILTER (

        'Product',

        [Date] = [Max date]

            && [Product] = SELECTEDVALUE ( 'Product'[Product] )

    )

)

The result is:

Is this the result you expect?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DmitryKo]

Why is this accepted as solution when SELECTEDVALUE would only work when there's exactly one value selected for a given dimension? There could easily me more than one or none Product(s) selected at all...

[Anonymous]

Thank you @amitchandak for the answer. I'll try those articles.

[amitchandak · Accepted solution]

@Anonymous , Refer my these two blogs

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

[DmitryKo]

Why can't we just use LASTNONBLANK/LASTNONBLANKVALUE here?