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:
Go to Solution.
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]
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
View solution in original post
Thank you, it works!
Glad to help 🙂
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.