Solved: Pick up values only for the latest date in the dat...

Anonymous · ‎07-30-2021

Hi team,

How can I pick up only the LATEST DATE VALUES in the DATASET using DAX. Example below

Input:

Customer	Value	Date
A	25	30/06/2021
B	90	30/06/2021
C	45	12/04/2021
D	15	11/06/2021

Output:

Customer	Value	Date
A	25	30/06/2021
B	90	30/06/2021

Jihwan_Kim · ‎07-30-2021

Value total Latest Date : =
VAR _latestdate =
CALCULATE ( MAX ( Data[Date] ), REMOVEFILTERS () )
RETURN
CALCULATE ( [Value total :], KEEPFILTERS ( Dates[Date] = _latestdate ) )

Link to the sample pbix file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Jihwan_Kim · ‎07-30-2021

Value total Latest Date : =
VAR _latestdate =
CALCULATE ( MAX ( Data[Date] ), REMOVEFILTERS () )
RETURN
CALCULATE ( [Value total :], KEEPFILTERS ( Dates[Date] = _latestdate ) )

Link to the sample pbix file

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.