Add new dynamic rows in existing table in power bi.

[unaseerb]

I have a table in which i have sales and type of the sales along with date. After each week i want to calculate the average of last 8 weeks and dynamically add new row with the average as sales and "Forecast" as the type.

Is it possible in power bi?

[v-yuta-msft · Accepted solution]

@unaseerb ,

I'm afraid power bi can't dynamic add rows of average values. Power bi only support add measures/calculate columns which can be changed dynamically with the data source. 

In your senario, I would suggest you write a trigger in database.

Community Support Team _ Jimmy Tao

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