How to get percent increase/decrease using 2 fields, one of which is a measure.

[croberts21]

I have Power BI Desktop for March 2023.

I have 2 fields which are columns I added: 

A column: Actual Hrs This Year = Jobcost[jcacthours]

Same Period Last Year = CALCULATE(SUM(Jobcost[jcacthours]), SAMEPERIODLASTYEAR('Calendar'[Mydate]) )

I want to show how much change there was from last year based on these 2 fields. So my calculation would be

('Actual Hrs This Year' - 'Same Period Last Year')/ 'Actual Hrs This year'

But I cannot get it to work, as I get various errors. The problem seems to be 'Same period last year' which uses the CALCULATE and SAMEPERIODLASTYEAR functions.

Does anyone know how to do what I need? 

Thank you!

[Ritaf1983 · Accepted solution]

Hi @croberts21 

If I understood you correctly.

You need 3 measures (not columns / fields)

Modify your first measure for :
1. Actual Hrs This Year =sum( Jobcost[jcacthours])

2. Same Period Last Year = CALCULATE([Actual Hrs This Year ], SAMEPERIODLASTYEAR('Calendar'[Mydate]) )

3.YOY % =( [Actual Hrs This Year] - [Same Period Last Year])/ [Actual Hrs This year]

Otherwise

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[croberts21]

Thank you, it works!

[Ritaf1983]

Glad to help 🙂