Forum Discussion
Time intelligence case!
Hi Guys, I have a large data set of monthly data over several years and have calculated last months sales using the following DAX. Total sales last month = CALCULATE ([Total sales]; ...
Hi Anonymous,
Can you do
Total sales last month = IF
(
CALCULATE ([Total sales]; DATEADD (Dates[Date];-1;MONTH ) ) = 0;
CALCULATE ([Total sales]; DATEADD (Dates[Date];-2;MONTH ) );
CALCULATE ([Total sales]; DATEADD (Dates[Date];-1;MONTH ) );
)
or were you hoping for something that would work backwards and find the fisrt non zero value?
Chris
Hi Anonymous,
Can you do
Total sales last month = IF
(
CALCULATE ([Total sales]; DATEADD (Dates[Date];-1;MONTH ) ) = 0;
CALCULATE ([Total sales]; DATEADD (Dates[Date];-2;MONTH ) );
CALCULATE ([Total sales]; DATEADD (Dates[Date];-1;MONTH ) );
)
or were you hoping for something that would work backwards and find the fisrt non zero value?
Chris