Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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
Hi ,
Check this if it helps
https://community.powerbi.com/t5/Desktop/Getting-all-dates-between-2-dates/td-p/60577
Cheers
CheenuSing
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...
Hello
thanks for your suggestion. I got the right figure partly, some are weird. refer following pic. where is wrong?
@hongyuliu ,Can you share sample data and sample output in table format
I have fixed the problem. Thank you.
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |