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 effective way to translate this over?

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Humanity,

    If these formulas are designed on the excel data table, you cna try to use the 'import' feature to import the whole workbook to power bi desktop. (it include current formulas)

    Import Excel workbooks into Power BI Desktop 

    If not, I think you need to manually convert these formulas with power bi Dax expressions logic. (since power bi data mode table not include column/row index, so these excel DAX functions not fully works on power bi desktop side)

    Regards,

    Xiaoxin Sheng

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