The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |