show date till which figures were available client wise

[Anonymous]

i want to flash client wise date till which last revenue numbers are available .

i know we can do it with max function to check latest date but there must be some function which is returning date by checking in some another column i.e revenue is available and then return the date.

Pls Help!!

[pranit828]

Hi @Anonymous 

Can you provide more details with sample input and output.

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can try these measures

Total Sales = SUM(Sales[Sales Amount])

Last Sales Date = LASTNONBLANKVALUE(Sales[Sales Date],max(Sales[Sales Date]) )

Last Sales = LASTNONBLANKVALUE(Sales[Sales Date],[Total Sales]) 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)