Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Yes But need to reorder things
if
Territory = if([Market] = "Sport"|| [Market] = "Profesionnal" && ([Region DO]="CA"||[Region DO]="WA"),"NorthWest","0")
If your issue is resolved, please kudos and mark this as resolved.
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
Yes But need to reorder things
if
Territory = if([Market] = "Sport"|| [Market] = "Profesionnal" && ([Region DO]="CA"||[Region DO]="WA"),"NorthWest","0")
If your issue is resolved, please kudos and mark this as resolved.
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
Ok try this :
Territory = if([Market] = "Sport" && ([Region DO]="CA"||[Region DO]="WA"),"NorthWest",0)
What error is it throwing?
Can you below syntax
Territory = if([Market] = "Sport" && [Region DO] = OR ("CA","WA"), "NorthWest",0)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |