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.
Hello Power Bi community
I have this challenge to find average compensation per month, and the averaging of each month only based on the current year
(This is just a sum dax. [Total Compensation] = SUM(amount))
Example, for 2021:
first 2 month has 1 average based of the first 2 month
(867+991)/2 = 929
First 3 month:
(867+991+919)/3 = 925
etc.
Hi @Anonymous .
If your date column contains data in MM-YYYY format, then I would recommend you to first create a Month calculated column using =TEXT([Date Column],”MM”) and then use the below DAX,
Avg. Compensation=
AVERAGEX(VALUES(DIM_DATE[MM-YYYY]),
[Total Compensation])
Else you can convert the same column in MM format and perform the DAX.
Regards,
Sanket Bhagwat.
If this post helps, then please consider iit as Accept as the solution.
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 |
---|---|
55 | |
25 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
63 | |
47 | |
17 | |
12 |