Forum Discussion
ahmer_malick
Helper II
Helper IIExcel 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...
FBergamaschi
Super User
Super UserYou 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