Forum Discussion
Switch function with multiples conditions
I cannot have the absolute solution since I do not know how does your model look like. But I have some ideas here that may help you out.
1. If you want to add Size as another condition, just need to use && in switch value.SALES = SWITCH(TRUE();
VALUES('Period Table'[PERIOD]) = "P6M" && 'Period Table'[SIZE] = "Small"; [P6M SALES ];
VALUES('Period Table'[PERIOD]) = "P6M YA" && 'Period Table'[SIZE] = "Medium"; [P6M YA SALES ];
BLANK())2. The other way of add multiple conditions is SWITCH inside a SWITCH:
Sales =SWITCH(TRUE(),VALUES('Period Table'[PERIOD]) = "P6M",SWITCH(TRUE(),VALUES('Period Table'[Size])="S","P6MS",VALUES('Period Table'[Size])="M","P6MM",VALUES('Period Table'[Size])="L","P6ML"),VALUES('Period Table'[PERIOD]) = "P6M YA",SWITCH(TRUE(),VALUES('Period Table'[Size])="S","P6M YAS",VALUES('Period Table'[Size])="M","P6M YAM",VALUES('Period Table'[Size])="L","P6M YAL"),BLANK())
Best,
Paul
I cannot have the absolute solution since I do not know how does your model look like. But I have some ideas here that may help you out.
1. If you want to add Size as another condition, just need to use && in switch value.
SALES = SWITCH(TRUE();
VALUES('Period Table'[PERIOD]) = "P6M" && 'Period Table'[SIZE] = "Small"; [P6M SALES ];
VALUES('Period Table'[PERIOD]) = "P6M YA" && 'Period Table'[SIZE] = "Medium"; [P6M YA SALES ];
BLANK())
2. The other way of add multiple conditions is SWITCH inside a SWITCH:
Best,
Paul