Forum Discussion
Solved
Comparing months with the same selected period
Hi people, I'm having a little trouble getting the following result: I'd like to get the amount of leads for the current month, the previous month and the month before the previous one according ...
Hi
DATEADD is meant to give the result in the selected date slicer. use these 3 dax
atual = CALCULATE(DISTINCTCOUNT(_leads[Id]),_leads[Produtos com nome do Reaal]<>BLANK())Atual -1 = CALCULATE([atual] , DATEADD(d_calendario[Date] , -1 , MONTH))Atual -2 = CALCULATE([atual] , DATEADD(d_calendario[Date] , -2 , MONTH))
Hi
DATEADD is meant to give the result in the selected date slicer. use these 3 dax
atual = CALCULATE(DISTINCTCOUNT(_leads[Id]),_leads[Produtos com nome do Reaal]<>BLANK())
Atual -1 = CALCULATE([atual] , DATEADD(d_calendario[Date] , -1 , MONTH))
Atual -2 = CALCULATE([atual] , DATEADD(d_calendario[Date] , -2 , MONTH))
