cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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
1 ACCEPTED SOLUTION
Solution Supplier

hello @SHILL

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")
Return
IF(
_Status="Start of year",
"",
IF(
_Status="Q1",
DIVIDE(_Q1,_StartofYear),
IF(
_Status="Q2",
DIVIDE(_Q2,_StartofYear)
)))

Thank you.
Solution Supplier

hello @SHILL

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")
Return
IF(
_Status="Start of year",
"",
IF(
_Status="Q1",
DIVIDE(_Q1,_StartofYear),
IF(
_Status="Q2",
DIVIDE(_Q2,_StartofYear)
)))

Thank you.