Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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 🙂
User | Count |
---|---|
88 | |
74 | |
69 | |
59 | |
56 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
28 |