Calculate the difference between two dates and two hours excluding days/WE

Question

Hi Microsoft community,&nbsp;I am a beginner with Power BI (I usually use Excel only)&nbsp;I need to calculate 2 things :- The number of hours between 2 dates and times, excluding WE and holidays.- The number of days between 2 dates, excluding WE and holidaysThe format of the two dates are like this :&nbsp;Date d'envoi&nbsp; &nbsp; Date approbation28/02/2020 15:36:38&nbsp; &nbsp; 02/03/2020 10:56:5502/03/2020 11:12:45&nbsp; &nbsp; 02/03/2020 11:18:32I need to do [Date approbation]-[Date d'envoi] excluding WE/holidaysI already have a table with the list of all the WE and holidays .&nbsp;&nbsp;Keep in mind that I am a beginner so if you have a simple solution, it will be great. I like to understand the solution and not only copy it.&nbsp;Thank you very much !&nbsp;Best regards,Alex&nbsp;

amitchandak · Accepted Answer

Anonymous , You can find out work days like this
a new column
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Date denvoi],Table[Date approbation),"WorkDay", if(WEEKDAY([Date],2) &lt;6,1,0)),[WorkDay] =1))
&nbsp;
You can also refer this for business refer
https://exceleratorbi.com.au/calculating-business-hours-using-dax/

Forum Discussion

Calculate the difference between two dates and two hours excluding days/WE

2 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

Exclude blank data from calculations

Calculating Differences

1. How to add two different calculated columns of two different table

Date d'envoi	Date approbation
28/02/2020 15:36:38	02/03/2020 10:56:55
02/03/2020 11:12:45	02/03/2020 11:18:32