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?

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)