Forum Discussion

mnirayo's avatar
mnirayo
Regular Visitor
7 years ago
Solved

Comparing chnages between a base year and current year

Dear Community,   I am able to compare the change in value between the current year and last year with the help of time intelligence DAX formulas. But, additionally, I want to compare the change in...
Data Modeling
  • Anonymous's avatar
    Anonymous
    7 years ago

    mnirayo ,

    Have you checked the PBIX file I attached? There are some issue with your data when you get infinity . Check the example below.


    You can change the measure to the following:

    Measure = Divide(CALCULATE(SUM(Table1[Value]),FILTER(Table1,Table1[Attribute]=2018)),CALCULATE(SUM(Table1[Value]),FILTER(Table1,Table1[Attribute]=2010)),0)-1



    Regards,
    Lydia