Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear Community,
I need your help with the following.
I have very simple calculation for Employees Turnover.
Here is the screenshot with the source table, summarized table for months and DAX for turnover measure.
Measure for months works just like it is required, but I need to do it better by addinf other way of calculation for Qtrs and Years or any periods longer than 1 month.
I need measure to sum up results for moths when longer than 1 month period is selected.
For example, if I want to calculate 2024 Qtr Turnover I need to sum Jan-2024 + Feb-2024 + Mar-2024 measure results.
The way of calculation that comes to my mind is to create special table with months results and then calculate the results for month, but I wonder if there is a more beautiful DAX solution without adding other table, I need new measure to work for tables and charts with date ierarchies.
Turnover = DIVIDE(
SUM(Data[Employees Left]),
(SUM(Data[Employee Number 1])+SUM(Data[Employee Number 2]))/2)
Thank you very much in advance!
Solved! Go to Solution.
@orinoko0 , Try using below measure
Turnover =
SUMX(
VALUES(Data[Month]),
DIVIDE(
SUM(Data[Employees Left]),
(SUM(Data[Employee Number 1]) + SUM(Data[Employee Number 2])) / 2
)
)
Proud to be a Super User! |
|
@orinoko0 , Try using below measure
Turnover =
SUMX(
VALUES(Data[Month]),
DIVIDE(
SUM(Data[Employees Left]),
(SUM(Data[Employee Number 1]) + SUM(Data[Employee Number 2])) / 2
)
)
Proud to be a Super User! |
|
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |