DAX last higher sales: When was the last time we sold more than today & how much was it?

Hi there,
I need 2 measures:

1) The last date when sales where higher than what my [SalesMAX] measure returns (so actually not today but the filter context of my SalesMAX measure: August 2015 in my example)

2) The sales amount that corresponds to 1)

LinkToFile

Any help very much appreciated - thank

September 11th, 2015 1:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics