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.
Hi!
I'm trying to create at table based of another table that calculates the average of a column per month that also filters out based on 2 other columns.
My data (this data will be expanded to contain data from way in the past and also new data from months to come)
I would like to create a new table or at least a way to present the average of column [SL 20] by month that is filtered if column [Antal besvarade samtal] or [Tappade samtal] is higher than 0.
My initial tought was to create a calculated table with columns for month and the sum of values in [SL 20] divided by number of rows that are higher than 0 in [Antal besvarade samtal] or [Tappade samtal].
To clarify (example data), the resulting table.
Hopefully someone can help me with this. Or maybe have a better way of accomplishing this.
Best regards,
Tommy Herman
Solved! Go to Solution.
Thank you @v-chuncz-msft!
With your help I managed to get it working with this folmula,
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |