topic Re: Percentage Difference in DAX Commands and Tips

Percentage Difference

SHILL — Wed, 10 Jul 2024 09:18:25 GMT

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

Re: Percentage Difference

Irwan — Thu, 11 Jul 2024 01:05:22 GMT

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")

Return

IF(

_Status="Start of year",

"",

IF(

_Status="Q1",

DIVIDE(_Q1,_StartofYear),

IF(

_Status="Q2",

DIVIDE(_Q2,_StartofYear)

)))

Hope this will help you.

Thank you.