Working minutes in POWER BI without holidays and no weekends.

[Xcris22]

Working minutes in POWER BI without holidays and no weekends. for the program from 09:00 to 17:00

I have two columns:
start_date and stop_date

NR	START	STOP
129056770	20/12/2018 11:53	20/12/2018 11:53
129056771	21/12/2018 11:01	21/12/2018 11:12
129056772	27/12/2018 13:55	27/12/2018 13:55
129056773	11/12/2018 14:34	11/12/2018 14:34
129056774	14/12/2018 16:38	14/12/2018 16:42

[parry2k]

@Xcris22 Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Please share data in excel using onedrive/google drive to get your answer quickly. Remove any sensitive information before sharing.

[Xcris22]

Done, thx for sugestion

[v-xuding-msft]

Hi @Xcris22 ,

Based on your sample data, I created a calculated column using DATEDIFF function to implement it. 

Working minutes = DATEDIFF('Table'[START],'Table'[STOP],MINUTE) 

 

If you need a measure, please try the formula below :

Measure = DATEDIFF(MAX('Table'[START]),MAX('Table'[STOP]),MINUTE)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Xcris22]

@v-xuding-msft 

need to exclude our Romanian holidays. and the programs  for work is  09:00 am-17:00 pm 

[v-xuding-msft · Accepted solution]

Hi @Xcris22 ,

I create a sample based on your data model. You could reference it to modify your report.

• Create a new column to relate to holidays table.

Day = 'Table'[START].[Date]

• Create a holidays table and create a one-one relationship between the tables.  (I get it from web.) 

• Create columns in "Table"

WeekDay = WEEKDAY('Table'[START],2)

Holiday = RELATED(Holidays[Day])

If work day = IF(OR('Table'[WeekDay]=6,'Table'[WeekDay]=7),0,IF(ISBLANK('Table'[Holiday]),1,0))

• Create a measure

Working minutes = CALCULATE(DATEDIFF(MAX('Table'[START]),MAX('Table'[STOP]),MINUTE),FILTER('Table','Table'[If work day]=1))

Edit :

If there is data that the start date and stop date are not same day in your table, you could reference the thread to have a try.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.