topic Re: how to calculate no of days in each month between startdate and enddate in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346405#M125651 <P>Total_Days=DateDiff(Min(Start_Date) , Max(End_Date),Day)</P> Mon, 24 Jul 2023 11:08:59 GMT Anonymous 2023-07-24T11:08:59Z how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346384#M125650 <P><SPAN>Hi everybody I am newbie with DAX.<BR /><BR /></SPAN>I have a vacation table, with startdate, enddate and employee id. I need to calculate no of days in each month(if start date and endate are two different months)<BR />for example<BR />id&nbsp; start_date&nbsp; &nbsp;end_date<BR />10 17/05/2023 12/06/2023<BR />I need to know howmany days in may and june separately<BR /><SPAN>Any help would be much appreciated. Thanks all!</SPAN></P> Mon, 24 Jul 2023 10:58:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346384#M125650 snehar 2023-07-24T10:58:03Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346405#M125651 <P>Total_Days=DateDiff(Min(Start_Date) , Max(End_Date),Day)</P> Mon, 24 Jul 2023 11:08:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346405#M125651 Anonymous 2023-07-24T11:08:59Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346507#M125656 <P>Hi,</P> <P>Please find attached my PBI file.</P> <P>Hope this helps.</P> <P><img /></P> Mon, 24 Jul 2023 12:08:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3346507#M125656 Ashish_Mathur 2023-07-24T12:08:31Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3347544#M125698 <P>hey , is it possible to get no of days in each month between startdate and enddate, as a new column in the same table?</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 24 Jul 2023 23:04:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3347544#M125698 snehar 2023-07-24T23:04:05Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3347635#M125701 <P>No, it is not.&nbsp; If the start and end dates span multiple months then one rows for each day should be created.&nbsp; You cannot create a row in a Table.</P> Tue, 25 Jul 2023 01:37:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3347635#M125701 Ashish_Mathur 2023-07-25T01:37:41Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348194#M125719 <P><SPAN>if there is multiple months like the screenshot i shared, of diiferent employees (startdate and enddate of vactaion taken of each employee)how do i get no of days in each month&nbsp;</SPAN></P> Tue, 25 Jul 2023 07:43:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348194#M125719 snehar 2023-07-25T07:43:36Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348209#M125721 <P><img /></P><P>&nbsp;</P> Tue, 25 Jul 2023 07:47:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348209#M125721 snehar 2023-07-25T07:47:14Z Re: how to calculate no of days in each month between startdate and enddate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348279#M125724 <P>The only way i am aware of is to transform the data in the Query Editor (I have already shared that file with you)</P> Tue, 25 Jul 2023 08:24:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-no-of-days-in-each-month-between-startdate-and/m-p/3348279#M125724 Ashish_Mathur 2023-07-25T08:24:50Z