Forum Discussion

Humanity's avatar
Humanity
Regular Visitor
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

can you send an example of the calculation you are importing ? 

Humanity's avatar
Humanity
Regular Visitor
6 years ago
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)))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The calculations dont seem that intense so I would duplicate the measures in DAX or just have the excel workbook do all the work and connect your power bi report to the output from excel.  

    • Humanity's avatar
      Humanity
      Regular Visitor
      6 years ago

      I'm trying to avoid DAX because long term we are translating everything to SQL down the road.

       

      Do you happen to know how to connect an Excel book to Power BI in a way that we can strill write to it using PowerApps input fields?