SHOW ONLY MATCHING VALUES

[Anonymous]

Hi,

I want to show values of lastest date for every client:

Example:

Client    Date           Amount

x	2019-03-01	30
x	2019-03-02	60
x	2019-03-03	20
y	2019-03-01	40
y	2019-03-02	50

Result

x	2019-03-03	20
y	2019-03-02	50

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

These measures work

Last date = MAX(Data[Date])

Value on last date = CALCULATE(SUM (Data[Amount]),LASTNONBLANK(Data[Date],SUM(Data[Amount])))

Hope this helps.

[Anonymous]

Thanks, It works for me too

[Ashish_Mathur]

If my reply helped, please mark it as Answer.