Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful 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
Super User
5 years ago

Pikachu-Power ,

Or you can create new Column like below Screen shot;

 

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
5 years ago

Doesnt work because we have other Names... see my Message 3.

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Pikachu-Power ,

     

    In my opinion, there is nothing wrong with the calculation logic. If it is caused by the data model, please provide a sample pbix to let us know your scenario more clearly.

    Please remove any sensitive data before uploading.

     

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