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

[Anonymous]

Hi Microsoft community,

I am a beginner with Power BI (I usually use Excel only)

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 holidays

The format of the two dates are like this : 

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

I need to do [Date approbation]-[Date d'envoi] excluding WE/holidays

I already have a table with the list of all the WE and holidays . 

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.

Thank you very much !

Best regards,

Alex

[v-jingzhang]

Hi @Anonymous 

You can first refer to below blogs about how to count working days and working hours. You may need some time to learn the functions and concepts involved. 

Counting working days in DAX - SQLBI

Power BI DATEDIFF only working days, hours and so on... • Tomasz Poszytek, Business Applications MVP

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak · Accepted solution]

@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) <6,1,0)),[WorkDay] =1))

You can also refer this for business refer

https://exceleratorbi.com.au/calculating-business-hours-using-dax/