Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |