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
Icon for Community Champion rankCommunity Champion
9 years ago

Hi Anonymous

 

Try with these measures and let me know:

 

Sales=Calculate(sum(public hec_ventas_ejecu[soles_vv]))

 

Salesof1YearBefore =Calculate([Sales],Sameperiodlastyear(public_dim_tiempo[Fecha]))

 

%IncreaseYoY=[Sales]/[Salesof1YearBefore]-1