Forum Discussion

Dythern's avatar
Dythern
Regular Visitor
2 years ago

Excel Trend function in Power BI

Hello Community! I am a beginner with Power BI and I want to ask for some help with the following calculation. I am transferring my Excel formulas to Power BI and am stuck with the trend functi...
Need Help
Dythern's avatar
Dythern
Regular Visitor
2 years ago

Hello Xiaoxin Sheng,

 

Thank you for addressing my problem!

 

I have created a sample Excel file from the original without sensitive data. It contains all the relevant functions I use.

I have also created a dummy data.xlsx and a dummy.pbix.

 

All the average calculations are working as expected.

 

I have tried two codes for trend calculation, but in both cases, the problem is, that it returns the sum of the total quantity. You can find these in the dummy.pbix.

 

I have uploaded the files to my Google Dive: LINK 

 

Thank you!