Forum Discussion

Resolver III

9 years ago

last date regardless context

Hi, everyone Please, help!!!!! The matrix is composed by: Rows: WeekCount --> Number of week regardless year (starts 01/01/2010) Rel.Week --> Relative week respect...

Need Help

Angel

Resolver III

9 years ago

Hi, v-ljerr-msft

It works!!!!!!.... Thank you, master!!!!!

The last thing I want to do is only consider sales where sales date > max fecha. To do that, I have tried with this phormula..

Sales amount after max snapshot = CALCULATE(MAX('Sales registered'[Sales amount]);FILTER('Sales registered';'Sales registered'[Sales Date] > [MaxDate]))

However, as you can see in the image above It doesn´t work...