Forum Discussion
Complex Excel Workbook into Power BI + PowerApps
We have an excel book with 10s of thousands of calculations run to generate output from input into a row. So I made a canvas app, and now must translate all the math over. What is the most effec...
can you send an example of the calculation you are importing ?
Anonymous
Here are some examples.
=IF($F20="",0,IF(Insulation!AS6="",0,Insulation!AS6))
=BF34*BD34
Y31: =IF($F31="",0,SUM(BR31:BU31)-SUM(AQ31:AT31)-(IF(OR(CE31=0,CE31=""),0,(CH31*CG31/CE31)/BI31))-IF(OR(BI31=0,BI31=""),0,(BJ31-CG31)/BI31))
AI34: =IF($F34="",0,IF((BF34-CD34)*Baseline!$K$75+IF(OR(CE34=0,CE34=""),0,(CD34*CH34)/CE34)-(AG34)-(AH34)<0,0.01,(BF34-CD34)*Baseline!$K$75+IF(OR(CE34=0,CE34=""),0,(CD34*CH34)/CE34)-(AG34)-(AH34)))