Forum Discussion
Solved
If Condition using SWITCH(TRUE)
Hello Everyone, I'm trying to create a IF condition (Calculated column) but seems my DAX is not working, any idea why PBI says "DAX Comparison Operations do not support comparing values of type i...
- manuelfigueira
Maybe you need smth like this. If it doesn’t help, please, share example of your data and desired result in order to help you
Action = SWITCH(
TRUE(),
[Split] = "FOOD", "RELEASE",
And([Status] = "Unmatched Standard", 'SAP'[Age] < 91), "HOLD",
And([Status] = "Unmatched Standard", AND('SAP'[Age] > 90, 'SAP'[Age] < 181)), "TIMING",
BLANK())
manuelfigueira
Maybe you need smth like this. If it doesn’t help, please, share example of your data and desired result in order to help you
Action = SWITCH(
TRUE(),
[Split] = "FOOD", "RELEASE",
And([Status] = "Unmatched Standard", 'SAP'[Age] < 91), "HOLD",
And([Status] = "Unmatched Standard", AND('SAP'[Age] > 90, 'SAP'[Age] < 181)), "TIMING",
BLANK())
Maybe you need smth like this. If it doesn’t help, please, share example of your data and desired result in order to help you
Action = SWITCH(
TRUE(),
[Split] = "FOOD", "RELEASE",
And([Status] = "Unmatched Standard", 'SAP'[Age] < 91), "HOLD",
And([Status] = "Unmatched Standard", AND('SAP'[Age] > 90, 'SAP'[Age] < 181)), "TIMING",
BLANK())
