Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
you are creating a meausre, pls provide the sample data and expected output.
Proud to be a Super User!
Please see the snippet. Below is something I am trying to do
Hi! Thanks for the responses but I am still not able to get through getting the correct results
@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
could you pls provide the sample data?
Proud to be a Super User!
Hi,
Share the download link of your PBI file and show the expected result. Also, do you want a calculated column or a measure?
Hi,
You should write a measure (not a calculated column). To get further help, share some data and show the expected result.
is this what you want?
Column = AVERAGEX(FILTER('Table',year('Table'[date])=year(EARLIER('Table'[date]))),'Table'[value])
Proud to be a Super User!
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.