Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have Power BI Desktop for March 2023.
I have 2 fields which are columns I added:
Solved! Go to 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
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
Thank you, it works!
Glad to help 🙂
Check out the November 2023 Power BI update to learn about new features.