Forum Discussion
Counting Working Days with criteria
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!
Memorable MemberHi 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!