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 the following 5 metrics organized by date. Instead of a final column (or possibly adding a column to the right of it), I’d like a cumulative average of each metric across these months. But also need the average to adjust when I slice out to fewer months/weeks/etc. So it’d be a 5 cell column with the average for metric 1, then metric 2, etc. across the columns to the left. Thanks for any help!
Hi @Anonymous,
If it is convenient, could you share your desired output so that we could help further on it?
Best Regards,
Cherry
I'm trying to remove the grand totals on the bottom and on the right. And add an average column on the right (so an average of each metric across time).
Hi,
So in the Total column, you want to see an Average. Am i correct? if Yes, then share the link from where i can download your PBI file.
Hi,
Sorry but i don't think that i undestand your question and your data very well. Someone else will help you.
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |