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

 

Need Help

5 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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'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 )
)