Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Increase % between two years

Hello, I'm new in this world of Power BI and I need some help. I've been trying to get the increase percentage of sales between 2 years. The sales are in the same column and there's a time dimensio...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    I recreate your tables in a reduce version:

     

    Relationships

     

    And Dax and Results

     

    Dax and Results

     

    You can try to modify Salesof1YearBefore :

     

    Salesof1YearBefore = Calculate([Sales],DATEADD(public_dim_tiempo[Date],-1,YEAR))

mitsu's avatar
mitsu
Resolver IV
9 years ago

One of the ways that you can try to aceive this is as follows . 

 

Create a Prior Year Sales Claculation  as

 

 CALCULATE(SUM([Sales]),SAMEPERIODLASTYEAR('Date'[Date]))

 

 

The percent inclrease can then be calculated as [Prior Year Sales]-[Sales]/[Sales]

 

 

Please make sure your date dimension is marked as a date table . 

 

 

Hope this helps !!

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Mitsu,

Thanks for your help, but your solution doesn't work :(