The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
User | Count |
---|---|
138 | |
109 | |
83 | |
69 | |
59 |
User | Count |
---|---|
258 | |
128 | |
116 | |
100 | |
80 |