https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtracting-by-Business-Days/m-p/3896204#M151842 <P>Hello All,</P><P>&nbsp;</P><P>What would be the DAX so subtract the Recorded Date from the Submitted Date in reference to only BUSINESS days? I would like to create a calculated column showing the number of days.&nbsp;</P><P>&nbsp;</P><P>Ex: The number of business days between December 1, 2023 and December 21, 2023 = 15</P><P><img /></P><P>&nbsp;</P><P>Thank you very much!</P><P>&nbsp;</P> Mon, 06 May 2024 17:54:36 GMT e175429 2024-05-06T17:54:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtracting-by-Business-Days/m-p/3896204#M151842 <P>Hello All,</P><P>&nbsp;</P><P>What would be the DAX so subtract the Recorded Date from the Submitted Date in reference to only BUSINESS days? I would like to create a calculated column showing the number of days.&nbsp;</P><P>&nbsp;</P><P>Ex: The number of business days between December 1, 2023 and December 21, 2023 = 15</P><P><img /></P><P>&nbsp;</P><P>Thank you very much!</P><P>&nbsp;</P> Mon, 06 May 2024 17:54:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtracting-by-Business-Days/m-p/3896204#M151842 e175429 2024-05-06T17:54:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtracting-by-Business-Days/m-p/3896374#M151856 <P>The function is called NETWORKDAYS&nbsp; but you need to provide the weekend and holiday dates.</P> Mon, 06 May 2024 19:21:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtracting-by-Business-Days/m-p/3896374#M151856 lbendlin 2024-05-06T19:21:22Z