calculate non-working days

[hongyuliu]

I have table to record the time of each machine operation.

Now I need to count how many days the machine doesn't operate in a month. what's the solution? Thank you

[amitchandak]

@hongyuliu , this one calculates the working date. You just need to reverse the working day flag, rest will work

https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0

[CheenuSing]

Hi ,

Check this if it helps

https://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/td-p/60577

Cheers

CheenuSing

[Greg_Deckler]

I would imagine you would also need an "End" column?

Perhaps See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[hongyuliu]

Hello

thanks for your suggestion.  I got the right figure partly, some are weird. refer following pic. where is wrong?

[amitchandak]

@hongyuliu ,Can you share sample data and sample output in table format

[hongyuliu]

I have fixed the problem. Thank you.