Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Variance Between Years

Hi,   I have 6-7 tables with different KPIs (Sales, distribution etc for year 2017 and 2018 calculated at Month,YTD and QTD. Example below   All i need is to show the variance between the years b...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Any help?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply. I think i am almost there

 

Two questions -1. I have Month, FY and YTD view for all the KPIs(altogether 7-8 in form of table), will the solution above handle this?

                          2. I have around 7-8 KPIs(volume, sales, promotion, index etc). So do i have to calculate Abs variance and Variance% for all of them?

 

Thanks!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

I do not understand your first question.  As regards the second one, the answr is yes.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Regarding question 1, attached is the view. you will find 3 views YTD,FY and Month. So my question was like for CY and PY, do i have to calculate separate measure for FY and Month. I am getting the results i need, all i am looking for is to find a way to calculate the Difference between Value of 2018 and 2017 in the matrix table.

     

    Reagarding 2nd Question, is not there any easy way. Because i am already creating around 24 dax query for 7 KPIs and for 3 different views(FY,YTD and Month)

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Any help?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I have marked as solved by mistake. I am still looking for the way out

         

        Greg_DecklerCan anyone please help me out here, i am almost there. I have everything i need for the dashboard. ALl i need is to find the way to calcualte vairiance and variance%