Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago

get value for last date

hello all,   For the measure = CALCULATE(SUM(Table[Value]), Table[Name] = "Amount") i get following results:     How can I get the value for the latest existing Calcdate? (in example just ...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

Pikachu-Power ,

Try this below DAx:

CALCULATE(Sum(Table[Value]),FILTER(Table,CalcDate = MAX(CalcDate)))

 

  • Pikachu-Power's avatar
    Pikachu-Power
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Thats what I tried first ğŸ™‚ I get BLANK then because beside Name = Amount I have other Name`s with CalcDate 19.01.2021. So in your formula MAX(CalcDate) = 19.01.2021 and there no values exist for Name = Amount.

     

    May possibe to Filter only Table[Name] for MAX?