Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

previous quarter - no data shown

Hi everybody,   I have an issue with the previous quarter function.   I try to compare revenue from current quarter with previous quarter but I don't have any amount calculated for previousquarte...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

mwegener thanks for your answer.

 

I now have information on my CApreviousquarter but the information is not relevant.

 

Filters selected on my report are : 

- Year

- Month 

 

So, if I choose 2020 and January, I would like to have the revenue for 2020 January AND the revenue of the previous quarter divided by 3 in comparison.

 

But the previous quarter revenue is not the expected amount...

 

What is wrong?

 

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

try this..

CA (last 3 months) =
CALCULATE (
    [CA];
    DATESINPERIOD ( Calendrier[Date]; MIN ( Calendrier[Date] ) - 1; -3; MONTH )
)