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 column called Basis Month and another column called Has Basis. I have been trying to find a formula online where i can find the average basis per month. Every formula I have tried does not work. Any help would be great!
Thank you
Solved! Go to Solution.
Check the type on your Has Basis column. If it is text, then convert it to decimal in the query editor.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this measure expression, replacing Table with your actual table name.
Avg By Month = AVERAGEX(VALUES(Table[Basis Month]), CALCULATE(AVERAGE(Table[Has Basis])))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Check the type on your Has Basis column. If it is text, then convert it to decimal in the query editor.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Group the table (or a copy of the table). Group by [Basis Month] and choose to Average [Has Basis].
Right click on the [Basis Month] column header and select "Group By" to get started.
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.