https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152793#M165050 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="625922" data-lia-user-login="bhanu_gautam" class="lia-mention lia-mention-user">bhanu_gautam</a>&nbsp;<BR />Thank you, it works perfectly!</P> Mon, 16 Sep 2024 15:24:53 GMT Anonymous 2024-09-16T15:24:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152201#M165011 <P>Dear Community,<BR /><BR />I need your help with the following.<BR /><BR /></P><P>I have very simple calculation for Employees Turnover.<BR />Here is the screenshot with the source table, summarized table for months and DAX for turnover measure.<BR />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.<BR />I need measure to sum up results for moths when longer than 1 month period is selected.<BR />For example, if I want to calculate 2024 Qtr Turnover I need to sum Jan-2024 + Feb-2024 + Mar-2024 measure results.<BR />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.<BR /><BR /></P><P>&nbsp;</P><P><img /></P><LI-CODE lang="markup">Turnover = DIVIDE( SUM(Data[Employees Left]), (SUM(Data[Employee Number 1])+SUM(Data[Employee Number 2]))/2)</LI-CODE><P><BR />Thank you very much in advance!</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 16 Sep 2024 10:00:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152201#M165011 Anonymous 2024-09-16T10:00:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152216#M165014 <P>Anonymous</a>&nbsp;, Try using below measure</P> <P>&nbsp;</P> <P>Turnover = <BR />SUMX(<BR />VALUES(Data[Month]),<BR />DIVIDE(<BR />SUM(Data[Employees Left]),<BR />(SUM(Data[Employee Number 1]) + SUM(Data[Employee Number 2])) / 2<BR />)<BR />)</P> Mon, 16 Sep 2024 10:08:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152216#M165014 bhanu_gautam 2024-09-16T10:08:29Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152793#M165050 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="625922" data-lia-user-login="bhanu_gautam" class="lia-mention lia-mention-user">bhanu_gautam</a>&nbsp;<BR />Thank you, it works perfectly!</P> Mon, 16 Sep 2024 15:24:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Different-DAX-calculation-for-Month-and-longer-periods-Qtrs/m-p/4152793#M165050 Anonymous 2024-09-16T15:24:53Z