Increase % between two years

[andrea9gutiampu]

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 dimension table where it contains the year.

Thanks for your help!!!

Relationships:

Matrix Result:

Thaaanks!!!

[mitsu]

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

[andrea9gutiampu]

Hi Mitsu,

Thanks for your help, but your solution doesn't work 😞

[v-micsh-msft]

Hi andrea9gutiampu,

What is your current situation?

Regarding Matrix, there is no way to remove the first column you marked in the visual. The values shows in that column is for the increase Precent, currently there is no customization available to hide the values that shows no input. For the Totals, we could disable it under the Format pane.

Format->General->Total Column

For the same amount per each city, this could be cuased by that the sales calculated is not associated with the city column(I mean they are not under the same table), or there might be issues regarding the relationships between those tables.

Post back if you need any further assistance.

Regards

[andrea9gutiampu]

Thanks Michael_Shao. It works!

[Vvelarde]

Hi @andrea9gutiampu

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

[andrea9gutiampu]

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 · Accepted solution]

@andrea9gutiampu

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

[andrea9gutiampu]

It really works! Thank you Vvelarde.