cancel
Showing results for
Search instead for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.

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

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.

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

Responsive Resident

Thank you, it works!

Super User

Glad to help 🙂

## Helpful resources

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors