Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Update formula in excel automate

Hi every one Could you please help me for this i have formula today in excel and i use this excel in power bi report i must open it every day to update this formula to effect in power bi so i want ...
update
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Anonymous ，

    If there is data model in excel, you could import the whole model into power bi, the calculated column will be imported too.

    https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

    Alternatively, you can take your formulas and convert them into dax in Power BI by means of measure or custom column. 

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ，

If there is data model in excel, you could import the whole model into power bi, the calculated column will be imported too.

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Alternatively, you can take your formulas and convert them into dax in Power BI by means of measure or custom column. 

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien