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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Vvelarde :)

I did what you explained, and the result between 2016 and 2015 was 0.00% ... in the matrix, when I included the measures: Sales=Calculate(sum(public hec_ventas_ejecu[soles_vv])) and Salesof1YearBefore =Calculate([Sales],Sameperiodlastyear(public_dim_tiempo[Fecha])), I got the same amount of sales per each city.

 

Please, if you can help me, I'll be very thankful.

 

Thanks!

 

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.