Forum Discussion
Wrong syntax for IF
Hi everyone,
I am beginner on Power BI and I try to do a new colonne on my dataset.
I don't understand why my DAX syntaxe is not correct .
I try to use 2 differents fields on same table for déterminate a new name with this two.
I would use a SWITCH because I think it's better but it can't use 2 différents fields.
Territory = if([Market] = "Sport" && [Region DO] = OR ("CA";"WA"); "NorthWest";0)
Could you help me please ?
Thanks,
Alex
6 Replies
When I try to check the Syntax, it say : "DAX can't compare text type with values True/False"
Hi everyone,
I am beginner on Power BI and I try to do a new colonne on my dataset.
I don't understand why my DAX syntaxe is not correct .
I try to use 2 differents fields on same table for déterminate a new name with this two.
I would use a SWITCH because I think it's better but it can't use 2 différents fields.
Territory = if([Market] = "Sport" && [Region DO] = OR ("CA";"WA"); "NorthWest";0)Could you help me please ?
Thanks,
Alex
Thanks !
And if I want to continue this request with more IF. I can do this ?
Territory = if([Market] = "Sport" && ([Region DO]="CA"||[Region DO]="WA");"NorthWest";"0") , if([Market] = "Profesionnal" && ([Region DO]="CA"||[Region DO]="WA");"NorthWest";"0")
Thanks for your answer
Alex
