Forum Discussion
Solved
Percentage Difference
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 |
hello SHILL
please check if this accomodate your need.
Create a measure wiht following DAX:
Calculate =var _Status = SELECTEDVALUE('Table'[Plan Forcasted])var _StartofYear = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Start of year")Var _Q1 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q1")var _Q2 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q2")ReturnIF(_Status="Start of year","",IF(_Status="Q1",DIVIDE(_Q1,_StartofYear),IF(_Status="Q2",DIVIDE(_Q2,_StartofYear))))Hope this will help you.Thank you.
1 Reply
hello SHILL
please check if this accomodate your need.
Create a measure wiht following DAX:
Calculate =var _Status = SELECTEDVALUE('Table'[Plan Forcasted])var _StartofYear = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Start of year")Var _Q1 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q1")var _Q2 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q2")ReturnIF(_Status="Start of year","",IF(_Status="Q1",DIVIDE(_Q1,_StartofYear),IF(_Status="Q2",DIVIDE(_Q2,_StartofYear))))Hope this will help you.Thank you.