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

     

     

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

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