Forum Discussion

nareshr89's avatar
nareshr89
Icon for Helper II rankHelper II
4 years ago

Growth Trend

tamerj1 @tamerI have 18 months data being loaded every month with the term Monthload. Each month load contains prior months actual and current & future months forecast values.   I have to obtain th...
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi nareshr89 ,

 

What is the final result like? Not sure which one you need in the end. Please share some sample data and the corresponding results.

 

Or you can create a summarize table to get all avg of each month. You can refer my pbix file.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.