Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi. I'm working on an area chart that contains defect counts and a static average of the defect counts. I was able to create a measure that produces a static average line. Now, I want to have the average line cut off to the current month and update when new data is refreshed each month.
Current measure to get average line:
Any ideas on how to update my current measure to get an average line that cuts off to the current data? (being sept in this case). Thanks.
Solved! Go to Solution.
@sshaw10 , Try this measure for line
Averagex(Values(Date[Month Year]), calculate(COUNTROWS('Table Data')))
@sshaw10 , Try this measure for line
Averagex(Values(Date[Month Year]), calculate(COUNTROWS('Table Data')))
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.