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.
An extract of the data looks like this:
sk_datum | fte | sk_management | SK_Medewerker |
20210331 | 1 | 618 | 14493 |
20210430 | 1 | 618 | 14493 |
20210531 | 1 | 618 | 14493 |
20210228 | 1 | 618 | 14493 |
20191031 | 1 | 618 | 14493 |
20191130 | 1 | 618 | 14493 |
20191231 | 1 | 618 | 14493 |
20200131 | 1 | 618 | 14493 |
20200229 | 1 | 618 | 14493 |
20200831 | 1 | 618 | 14493 |
The last 2 columns link to an employee dimension, and an org chart.
On these 2 dimensions, I would like to sum the FTE's. However on the date dimension, I would like to aggregate by average.
For your information, the date column will always contain one date value per month.
Solved! Go to Solution.
@jvandyck , one of the ways. have a measure like this
averageX(values(Date[Date]), [Measure])
@jvandyck , one of the ways. have a measure like this
averageX(values(Date[Date]), [Measure])
I did investigate further and got it to work now. My first try was the following formula:
Thanks for your quick reply. I tried your suggestion but it does not seem to work. Here you can find a mock-up: https://www.dropbox.com/s/udqez5pngu2x5wn/Thuiswerk%20test.pbix?dl=0
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |