Forum Discussion
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...
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
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
https://1drv.ms/u/c/2b099a8a26629d49/EcAEcV0Z1qFJmkbHjBWvFEwBdGq3BW073cBJL_QxFzUSyw?e=FeD0Uw
Please find the attach PBIX file link.