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

Hi,

 

It is example of output, Another Screen shot below and a small data set. Hope this helpSample DataEnd output

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

OK, a couple last questions, you already have YTD 2017 and YTD 2018 measures, correct? Also, is there any reason you cannot just UNION or Append all 6 or 7 tables together?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for your reply. I cannot use union or append as i am aiming to have this output tables displayed in the interface(like a tree) with filters for users to get desired output by selecting Customers, brands etc. Another reason is i have Month and FY too similar to YTD that i created using switch function(table stays as is, only the value change upon selection of YTD, Month and FY)

     

    Is not there any way where we can just simply substract value of 2018-2017 of volume and sales(for variance abs) and Variance abs/2017(for variance%) value in the same table?

     

    Final view wpuld be like in the link, query i posted a month ago https://community.powerbi.com/t5/Desktop/Produce-Table-hierarchy-from-raw-data/m-p/532661