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.
I am transitioning from Tablau to PowerBI, and having an issue writing a new Column statement in DAX. My statement in Tableau works similar to Excel ands reads as follows:
IF ([App Status]="AC" OR [App Status]="AR" OR [App Status]="AM" OR [App Status]="ACOM") THEN "Y" ELSEIF ([App Status] = "Can" OR [App Status] = "Def" OR [App Status] = "NoCon" OR [App Status] = "W") AND [App Status Date]<=[SumDate] THEN "N" ELSE "Y" END
I tried the syntax including the OR statement on the outside, but it gave an error. Also, wasn't clear on the ElseIf capabilities.
Any help would be greatly appreciated.
Solved! Go to Solution.
@rrhutch Like @Dan80 mentioned DAX syntax is different OR is || and AND is && for more than two conditions, plus you need to add semicolon or comma depends region delimiter settings like excel.
IFDAX = IF ( [App Status] = "AC" || [App Status] = "AR" || [App Status] = "AM" || [App Status] = "ACOM"; "Y"; IF ( [App Status] = "Can" || [App Status] = "Def" || [App Status] = "NoCon" || [App Status] = "W" && [App Status Date] <= [SumDate]; "N"; "Y" ) )
Or a better sformula for nested IF is SWITCH
SWITCHDAX = SWITCH ( TRUE; [App Status] = "AC" || [App Status] = "AR" || [App Status] = "AM" || [App Status] = "ACOM"; "Y"; [App Status] = "Can" || [App Status] = "Def" || [App Status] = "NoCon" || [App Status] = "W" && [App Status Date] <= [SumDate]; "N"; "Y" )
I suggest you to check DAX formula language definitions , at least on begginning
@rrhutch Like @Dan80 mentioned DAX syntax is different OR is || and AND is && for more than two conditions, plus you need to add semicolon or comma depends region delimiter settings like excel.
IFDAX = IF ( [App Status] = "AC" || [App Status] = "AR" || [App Status] = "AM" || [App Status] = "ACOM"; "Y"; IF ( [App Status] = "Can" || [App Status] = "Def" || [App Status] = "NoCon" || [App Status] = "W" && [App Status Date] <= [SumDate]; "N"; "Y" ) )
Or a better sformula for nested IF is SWITCH
SWITCHDAX = SWITCH ( TRUE; [App Status] = "AC" || [App Status] = "AR" || [App Status] = "AM" || [App Status] = "ACOM"; "Y"; [App Status] = "Can" || [App Status] = "Def" || [App Status] = "NoCon" || [App Status] = "W" && [App Status Date] <= [SumDate]; "N"; "Y" )
I suggest you to check DAX formula language definitions , at least on begginning
Thanks. That was helpful.
OR and AND functions in DAX have a limit of just 2 conditions so to get around the problem, instead of using OR, use | character and AND use &&. These allow you to use more than 2 conditions. Hope this helps?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |