I am facing and issue with Average function where it returns the same values as they are in original rows.
First Column represents some numbers and the last column I am trying to do average. I am using and excel sheet. I want to filter the values out by Column 2 and the date column. The data is for 2021 and 2022
@ryan_mayu Hey Ryan! I was able to solve the issue! Thanks for all the help. I first created a measure and then plugged that in a column to calculate and divide
Share the download link of your PBI file and show the expected result. Also, do you want a calculated column or a measure?
You should write a measure (not a calculated column). To get further help, share some data and show the expected result.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.