Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I was hoping someone could help. I have a measure below. Its great for creating a measure that gives average of number employees over the last 12 rolling months. I`m looking for a measure that will give me the average number of employees for within the specific year and not the rolling 12 months. Altering the below or another suggestion would be great.
Thanks, in advance,
Brendan
Solved! Go to Solution.
Measure = calculate(average ([total FTE]))
Then show per year in your dashboard
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Measure = calculate(average ([total FTE]))
Then show per year in your dashboard
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Just do an average , not averagex, and slice by year?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Thanks. How do you suggest doing the average? Adjusting the measure submitted while changing averagex to average? Or create a new measure.
Brendan