Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Need help with multi IF statements

I have attached my PBIX file here. I am trying to create a column ("Difference to 5-Star condition3") with outputs based on the logic below:   -----------------------------------------------------...
"DAX " "DAX help" 'Need help'
  • danextian's avatar
    danextian
    1 year ago

    Hi JustinDoh1 

     

    Please try this:

    Difference to 5-Star condition3 = 
VAR _ShortStayScore = tblSLTC_FSPI[ShortStayScore]
VAR _LongStayScore = tblSLTC_FSPI[LongStayScore]
VAR _ShortLongScore = _ShortStayScore + _LongStayScore
VAR _Diff1 = 1456 - _ShortLongScore
VAR _Diff2 = 736 - _LongStayScore
RETURN
    SWITCH (
        TRUE (),
        _ShortStayScore <> _LongStayScore, MAX ( _Diff1, BLANK () ),   --blank is bigger than negative
        tblSLTC_FSPI[ShortStayLogic] = "Not Reported", MAX ( _Diff2, BLANK () )   --blank is bigger than negative
    )

     

    burakkaragoz Let us please not rely too much on AI and validate the solutions we provide.  ShortStayScore and LongStayScore are both numbers so comparing them with text in variable BothScoresReported will return an error. 

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hi JustinDoh1,
Thank you for reaching out to the Microsoft fabric community forum.

I have reproduced your scenario in Power BI Desktop and successfully achieved the expected output as per your requirements.

For your reference, I’m attaching the .pbix file containing the solution. You can download it and review the setup to apply it to your report.


If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.