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

Import your excel wokr book into power bi and it should recognize the calculaitons 

  • Humanity's avatar
    Humanity
    Regular Visitor
    6 years ago

    Anonymous 

     

    It turns all the tables into static text while it imports.  So you get the calculation results but not the calculations.

     

    Unless you know of some way around that?

    • 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)))