cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Responsive Resident

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

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!

1 ACCEPTED SOLUTION
Super User

If I understood you correctly.

You need 3 measures (not columns / fields)

Modify your first measure for :
1. Actual Hrs This Year =sumJobcost[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.

Regards,
Rita Fainshtein | Microsoft MVP
3 REPLIES 3
Super User

If I understood you correctly.

You need 3 measures (not columns / fields)

Modify your first measure for :
1. Actual Hrs This Year =sumJobcost[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.

Regards,
Rita Fainshtein | Microsoft MVP
Responsive Resident

Thank you, it works!

Super User

Regards,
Rita Fainshtein | Microsoft MVP