Counting Working Days with criteria

[Anonymous]

Hi All,

Hope everyone is doing well.
I need some more help with adding a column instead of a measure, please 

Find the # of Days Working between Start Date and First Open Time with the criteria of:

1. Answer = Accept
2. Status <> Void

3. First Open Time after Start Date

4. Counting the Working Days, I have a dates table that counts each work day as 1, column name Is Weekday

[Migasuke · Accepted solution]

Hi @Anonymous ,

I solved your issue but it consists of several steps. The results are the same as you sent me later in the printscreen.

Solution is following:

1. Create an Index column in Power Query. This will help identify which data input is earlier or later.

2. Create new column called DateDiff. This will be used later for filtering + giving results. Formula is following:

3. Create new column with the Result. This DAX formula copies the logic you have. The most crucial part is within CALCULATE and MINX, where we specify which data we need to filter. Here the Index column is needed.

Let me know if you have any other question!

[Migasuke]

Hi @Anonymous ,

Can you please give example of a result?
Do you want to calculate days only for fulfilled criteria? And what do you want to see if the criteria is not fulfilled?