Forum Discussion
Anonymous
7 years agoNot applicable
Tricky Switch Function using selection slicers
Hi Experts See Attached file link on one drive i am trying to write a swicth function - see folder PL Hyperion Summary - Measure "Test". Which give the net sale value based on the selection cri...
- 7 years ago
Hi Anonymous,
Try to simplify and make the measure below.
Test = VAR Timeframe = SELECTEDVALUE ( Periods[Period] ) VAR Selction = SELECTEDVALUE ( Activity[Scenario] ) VAR AOP = SWITCH ( Timeframe; "MTD"; [AOP Total Management]; "QTD"; [AOP QTD Total Management]; "YTD"; [AOP YTD Total Management]; [AOP Total Management] ) VAR PY = SWITCH ( Timeframe; "MTD"; [PY Total Management]; "QTD"; [PY QTD Total Management]; "YTD"; [PY YTD Total Management]; [PY QTD Total Management] ) RETURN SWITCH ( Selction; "AOP"; AOP; "PY"; PY; BLANK () )I'm making one variable for AOP another for PY this will had the possbility to have line 16 in the formula, on the last line I'm returning to the variables to get the result.
Please check if you have the expected result for all alternatives.
Regards,
MFelix
MFelix
7 years agoSuper User
Hi Anonymous,
Try to simplify and make the measure below.
Test =
VAR Timeframe =
SELECTEDVALUE ( Periods[Period] )
VAR Selction =
SELECTEDVALUE ( Activity[Scenario] )
VAR AOP =
SWITCH (
Timeframe;
"MTD"; [AOP Total Management];
"QTD"; [AOP QTD Total Management];
"YTD"; [AOP YTD Total Management];
[AOP Total Management]
)
VAR PY =
SWITCH (
Timeframe;
"MTD"; [PY Total Management];
"QTD"; [PY QTD Total Management];
"YTD"; [PY YTD Total Management];
[PY QTD Total Management]
)
RETURN
SWITCH ( Selction; "AOP"; AOP; "PY"; PY; BLANK () )
I'm making one variable for AOP another for PY this will had the possbility to have line 16 in the formula, on the last line I'm returning to the variables to get the result.
Please check if you have the expected result for all alternatives.
Regards,
MFelix
Anonymous
7 years agoNot applicable
Spot on.....God Bless