Working Day Calculation

[Anonymous]

Hello,

I want to show working day in my report for the production plan.

My Excel file: https://hizliresim.com/78TFVA
In the work days Column, 1 is the meaning working days of the factory, and 0 is the closed day of the factory.

That's what I want it to look like in the report.
https://i.hizliresim.com/cWJ8a3.jpg

In my report, I want to see what work day we are on and how many work days we have left.
Can you help me please?
Regards,
Koray

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

We can use the following steps to meet your requirement.

1. Create a measure that calculate the total of work day.

total day = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Work Days]=1))

2. Create a measure that calculate the remaining work day.

remain work day = 
var work_day = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Work Days]=1 && 'Table'[Date]<=TODAY()))
return
[total day]-work_day

3. Then we can get the result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

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

[Anonymous]

Is there anyone that can help? 😞

[amitchandak]

Assume April is selected as the slicer

Measure  =

calculate(sum(Table[Working day]),Table[Date]<=today())/calculate(sum(Table[Working day]))

[Anonymous]

Hello,

Thank you for reply. Did not work properly 😞

https://hizliresim.com/2nfnfA

https://hizliresim.com/YLsu3Q