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
Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
5 years ago

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

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity 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.