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...
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