How to calculate in Power BI the %increase measure?

[kasti]

Hello, 

I have created a table as below and I would like to calculate % increase between "Current" and "LY Actuals" i.e. for Sales it will be 4% (52-50)/50. How can I code this? Thanks for help!

Example:

Here are the setting of this table, and the Sales & Orders are a calculated measures.

[kasti]

Thanks @cursed for the 2nd option. It worked very well! 🙂

[cursed]

No worries at all, happy that I could help solve your problem 🙂 

[kasti]

Thanks for suggestion. I don't have a column called "Last Year" and "This Year" but both are included in one column as "Scenario". As such I could not follow the formula above. How to refine it?

[cursed · Accepted solution]

Apolgise had to repost as I made a mistake on the previous post, so the forumla should be:

Test_Measure =

Var LY_sales = CALCULATE(SUM(Enter_your_table_name[Sales]),FILTER(Enter_your_table_name,Enter_your_table_name[Short name] = "LY Actuals"))

 

Var Current_sales = CALCULATE(SUM(Enter_your_table_name[Sales]),FILTER(Enter_your_table_name,Enter_your_table_name[Short name] = "Current"))

Return

(Current_sales - LY_sales) / LY_sales

Which should look somthing like this when you format it as a mesaure:

 Below is screen grab of the results returned:


Please let me know if you have any further questions, I've created the forumla so it should just plug and play in to the Dashboard all you need to do is change the table name.

Please do let me know if you require furhter assitance 

Many Thanks

Ben

[cursed]

Hey,

So the forumla I would use to solve this problem is as follows:

% Increase = ( ( SUM('Table'[This Year]) - SUM('Table'[Last Year] ) ) / SUM('Table'[Last Year] ) )

*You might notice I haven't times it by 100 which is what would normaly do, this is because Powerbi has button you can press which will format the number as a percentage [See screenshot below]

You should end up with somthing like this:

Please let me know if you have any further questions,

Many Thanks
Ben