The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have the example graph below and I need to get a percentage that shows the difference against our start of year plan. For example, the start of the year plan we forecast a total of 30 sales, the Q1 plan forecasted a total of 37, which is 185% against the start of year plan. Then Q2 we forecast which is 300% against the start of year plan. Is there a measure I can use to get this
Plan Forcasted | Month | Totals | |
Start of year | JAN | 5 | |
Start of year | FEB | 10 | |
Start of year | MARCH | 5 | |
Q1 | JAN | 7 | |
Q1 | FEB | 10 | |
Q1 | MARCH | 20 | |
Q2 | JAN | 10 | |
Q2 | FEB | 20 | |
Q2 | MARCH | 30 |
Solved! Go to Solution.
hello @SHILL
please check if this accomodate your need.
Create a measure wiht following DAX:
hello @SHILL
please check if this accomodate your need.
Create a measure wiht following DAX:
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
27 | |
12 | |
12 | |
12 | |
6 |