Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
orinoko0
Frequent Visitor

Different DAX calculation for Month and longer periods (Qtrs, Years or any periods longer than Month

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.

 

orinoko0_0-1726480569220.png

Turnover = DIVIDE(
    SUM(Data[Employees Left]),
    (SUM(Data[Employee Number 1])+SUM(Data[Employee Number 2]))/2)


Thank you very much in advance!

 

 

1 ACCEPTED SOLUTION
bhanu_gautam
Super User
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
)
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






View solution in original post

2 REPLIES 2
orinoko0
Frequent Visitor

@bhanu_gautam 
Thank you, it works perfectly!

bhanu_gautam
Super User
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
)
)




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.