If Condition using SWITCH(TRUE)

[manuelfigueira]

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 integer with values of type Text. "",

Is there any other way to use IF functions below?

Thanks a lot!

Action = SWITCH(TRUE(),

[Split] = "FOOD", "RELEASE",

[Status] = "Unmatched Standard", AND('SAP'[Age] < "91", "HOLD"),

[Status] = "Unmatched Standard", AND('SAP'[Age] > "90", AND('SAP'[Age] < "181", "TIMING")),

BLANK())

[az38]

hi @manuelfigueira 

try without quotas

Action = SWITCH(TRUE(),
[Split] = "FOOD", "RELEASE",
[Status] = "Unmatched Standard", AND('SAP'[Age] < 91, "HOLD"),
[Status] = "Unmatched Standard", AND('SAP'[Age] > 90, AND('SAP'[Age] < 181, "TIMING")),
BLANK())

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[manuelfigueira]

Hi @az38 

Thank you very much for the below! I tried, the columns [Age] are Text so the quotas are alright, but I believe is there something related with the function itself, 

The original function is this:

=IF(SAP[SPLIT]=""FOOD"",""RELEASE"",

  IF(AND(SAP[Status]=""Unmatched Standard"", SAP[Age]<91),""HOLD"",

  IF(AND(SAP[Status]=""Unmatched Standard"",AND(SAP[Age]>90,SAP[Afe]<181)),""TIMING"",""RELEASE"")))"

I think part the solution is how do you create a logic chain with the above?

[az38 · Accepted solution]

@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]

@az38 You are a genius! thank you very much for this!