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,AX...
Need Help
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