previous quarter - no data shown

[Anonymous]

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 previousquarter. 

So, I guess my formula is wrong. Could someone please help me? 

CA_PreviousQuarter =

-calculate(

sum('Xyz$G_L Entry'[Amount]);

previousquarter(Calendrier[Date]);

FILTER('Xyz$G_L Entry';

'Xyz$G_L Entry'[G_L Account No_] IN {700000}

&& NOT ('Xyz$G_L Entry'[Source Code] IN {"CPTACLGEST"})

&& NOT ('Xyz$G_L Entry'[Global Dimension 1 Code] IN {"901Admin";"911IT";"921Fin";"931Dir";"941Mkt";"902HORSEXPL"})))

Have a nice day

[mwegener]

Hi @Anonymous ,

try this

CA =
- CALCULATE (
    SUM ( 'Xyz$G_L Entry'[Amount] );
    FILTER (
        'Xyz$G_L Entry';
        'Xyz$G_L Entry'[G_L Account No_] IN { 700000 }
            && NOT ( 'Xyz$G_L Entry'[Source Code] IN { "CPTACLGEST" } )
            && NOT ( 'Xyz$G_L Entry'[Global Dimension 1 Code]
            IN { "901Admin"; "911IT"; "921Fin"; "931Dir"; "941Mkt"; "902HORSEXPL" } )
    )
)

CA_PreviousQuarter =
CALCULATE ( [CA]; DATEADD ( Calendrier[Date]; -1; QUARTER ) )

[Anonymous]

@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?

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

For example, for 2020 January, the expected result of the previous quarter should be ( data for 2019/10, 2019/11, 2019/12)/3

for 2020 April, the expected result should be (data for 2020/1, 2020/2, 2020/3)/3,

Right?

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft  that's exactly what I would like...

[mwegener]

Hi @Anonymous ,

try this..

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