Forum Discussion

jfern78's avatar
jfern78
Frequent Visitor
2 years ago

Calculate % difference between two years

I would like to work out % difference between 2 years for a set of values and having some trouble doing so.   First of all, let’s say I have the following sample of data   Year Active/Inacti...
some_bih's avatar
some_bih
Community Champion
2 years ago

Hi jfern78 I would recommend you to check link below, part Year-over-year growth, as this is one of the best practice. This solution require Calendar / Date table (and your data from Fact table as date type), but article is worth reading and implementation for your case. 

Hope this help, kudos appreciated.

 

https://www.daxpatterns.com/standard-time-related-calculations/ 

  • jfern78's avatar
    jfern78
    Frequent Visitor
    2 years ago

    Thanks, i will see it. i'm figuring out how to do it.

  • jfern78's avatar
    jfern78
    Frequent Visitor
    2 years ago

    i made a column with correct FY Year/date, but when i try to calculate last year sales return me blank.

     

    Total Sales Last Year = CALCULATE([Total Cartera Activa],dateadd('Cartera Total'[Fiscal Date],-1,Year))

     

    • some_bih's avatar
      some_bih
      Community Champion
      2 years ago

      Hi jfern78 use Date / Calendart table to "leverage" proper usage of Power BI time intelligence functions like YTD, MTD... do not put fact table year column in visual.