Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I trying to calculate a Average Headcount (basically is the sum of Monthly HeadCount / number of months). The Monthly HeadCount is the measure that calculates a total value for the month.
for example:
SET OUT NOV DEZ JAN
Monthly HeadCount 400 430 450 445 480
Average Headcount 400 415 427 431 441
does anyone have any idea how to calculate this measure?
Thanks!
Solved! Go to Solution.
Hi @guilherme_gq,
I would suggest you create a date table if you don't have one. Please check out the demo in the attachment.
Measure = CALCULATE ( AVERAGEX ( SUMMARIZE ( 'Table', 'Calendar'[MonthNum], "v", [Monthly HeadCount] ), [v] ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) && 'Calendar'[Date] <= MAX ( 'Table'[Date] ) ) )
Best Regards,
Dale
Hi @guilherme_gq,
Could you please mark the proper answer as a solution?
Best Regards,
Dale
Hi @guilherme_gq,
Could you please mark the proper answer as a solution?
Best Regards,
Dale
Hi @guilherme_gq,
I would suggest you create a date table if you don't have one. Please check out the demo in the attachment.
Measure = CALCULATE ( AVERAGEX ( SUMMARIZE ( 'Table', 'Calendar'[MonthNum], "v", [Monthly HeadCount] ), [v] ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) && 'Calendar'[Date] <= MAX ( 'Table'[Date] ) ) )
Best Regards,
Dale
Thanks, man!!!
that worked!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |