Forum Discussion

ahmer_malick's avatar
ahmer_malick
Helper II
1 year ago

Excel to Powerbi conversion formula help

Need Help with 2 formula . I have a report in Excel , I would be move it in PWBI as its taking alot

Formula one in excel :-

=IF(Z3="Y","N",IF(H3=1,"n",IF(AND(AN2="Y",F2=441277),"Y",IF(AND(J3>=H3,AX3="not@pack"),"N", IF(Q3>0,"Y",(IF(OR(AM3="Y",AC3="Y",AI3="Y",AE3="Y",(AND(W3="Y",Z3="N",X3="N"))),"Y","N")))))))

 

Formula 2 

=IF(C2="","N",IF(AL2="Y","N",IF(AND(AN5="Y",C2=C5),"N",IF(AND(D2=525,J2>0,AX2="NOT@PACK"),"N",IF(AND(AN4="Y",C2=C4),"N",IF(AND(AN2="Y",C2<>C3,J2<H2),"Y",(IF(H2=1,"N",(IF(AND(AN2="Y",AN3="N"),"Y","N"))))))))))

 

Need Help

13 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Super User
    1 year ago

    You need to use the IF DAX function and use colum names instead of cell references

     

    Anyway I see you reference in one row cells of toher rows, this is complex in DAX

     

    But is this you need to build a column or a measure?

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

    • ahmer_malick's avatar
      ahmer_malick
      Helper II
      1 year ago

      I need to built a calculated column . We don't post qty as 2 operations occur simultaneously so checking other operation no if anything is posted afterwards in the SHOP order

      • FBergamaschi's avatar
        FBergamaschi
        Super User
        1 year ago

        This is a complex thing to implement, I believe a visual calculation might be a better solution but without your entire pbix file I cannot help you

         

        If this helped, please consider giving kudos and mark as a solution

        me in replies or I'll lose your thread

        consider voting this Power BI idea

        Francesco Bergamaschi

        MBA, M.Eng, M.Econ, Professor of BI

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support
    1 year ago

    Hi ahmer_malick ,

    Thanks for reaching out to the Microsoft fabric community forum.

    FBergamaschi 

    Thanks for your prompt response

     

    ahmer_malick 

    Thanks for sharing the Power BI (.pbix) file earlier. I tried accessing it via the OneDrive link, but I’m getting an error saying the item might have been deleted, expired, or I don’t have permission to view it (screenshot attached).

    Could you please re-share the file with the correct permissions? 

    Thanks in advance!

    Best regards,
    Lakshmi Narayana