Forum Discussion

BuistJF's avatar
BuistJF
Helper I
3 years ago

MdxScript(Model) (29, 5) Calculation error in measure, though was previosuly working

I have the following DAX that aims to bring back the date where the highest running total was achieved. i.e. the date 09/09/22 would show because it had the highest running total, say 1000. Every day...
Need Help
johnt75's avatar
johnt75
Super User
3 years ago

It looks like more than one date has the same max value. Try changing VALUES to MAX.

BuistJF's avatar
BuistJF
Helper I
3 years ago

Legend, thank you!