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.
I would like to achieve a measure to calculate an average of employee count based on the dates that are pulled in. For example, using the screen shot below, for Dec 22 the calculation would be =AVG(SUM(2285+2328),2).....2 in the equation is the count if current period and previous period.
the Jan 2023 denominator would be 3 and so forth.
I need the formula to be adaptable for any range of periods.
Solved! Go to Solution.
1-In your DateTable, Create a calculated column as below:
1-In your DateTable, Create a calculated column as below:
Hi! Thank you for the quick response, the YEAR & MONTH functions are not allowing me to select a table[column], only measures. Am I doing something wrong?
I think your are putting it in a measure so it is the reason.
Create it as a calculated column. Then it would be OKay.
Okay figure that out. These are my results. The second image are the numbers I am trying to get to...
Did you put latest version of my measure?
It includes variables.
Yes! I have updated the measure and I am getting all sorts of errors...
It is because you do not have set any name for your measure.
MeasureName=
My Formula
Yikes! Rookie here. 🙂 It worked! That is awesome! One last thing do you know why the Index would be duplicating like this:
Should not be like that.
Send your formula. Is it set on "Don't be summarized" option?
Discard figured it out! Thank you so much for your help!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |