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))

Vvelarde's avatar
Vvelarde
Community Champion
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))

Anonymous's avatar
Anonymous
Not applicable
9 years ago

It really works! Thank you Vvelarde.