Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |