Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MOM, QoQ, YoY calculation

Hi,

 

This is regards to the MoM, QoQ & YoY calcialtion of Variance,Financial Year starts from April. attached is the data Format.

 

 

Just similar to above i ve a data since FY14 till date.

Note: 

1.Fy starts from April

2. Clients are duplicated in each month along with revenue.

Need to calcualte variance MoM, QoQ and YoY in the format below:

Please help me at the earliest,

 

REgards,

varun

Need Help

19 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

     

    hi, Anonymous 

    You need to add a Financial calendar table and then create the relationship with data "Month" column.

    Then use DATEADD or PREVIOUSMONTH Function to calculate previous month data as below:

     

    Measure = CALCULATE(SUM('Table'[Sales]), DATEADD('FY calendar'[Date], -1, MONTH))

    or

     

    Measure = CALCULATE(SUM('Table'[Sales]), PREVIOUSMONTH('FY calendar'[Date]))

    Then drag date field from Financial calendar table into visual

    If not your case, please share some simple and complete data with your expected output.

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi All,

       

      After some workout on the data there are some findings as mentioned below:

       

       

      1. As mentioned, my fianncial Yaer starts from April to Mar and 've a data from FY14.

      2.  Used All select Month name to filter but could not get

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

        Share some data in a format that can be pasted in MS Excel.