Forum Discussion
dsj8wksnnckk
Resolver I
Resolver ICount work days between two dates but from different months
Hi all, I've been struggling how to solve the following problem. I have a dataset that looks something like this after Power Query and some DAX filtering: Beside this table, I have a ...
I have resolved this with Power Query.
1. Created a list of dates using List.Date (created a new row for each date between the From and To dates)
2. Added a new column to check if the date is work day or not
3. Connected with Date table
4. Used COUNTROWS
dsj8wksnnckkResolver I
Resolver II have resolved this with Power Query.
1. Created a list of dates using List.Date (created a new row for each date between the From and To dates)
2. Added a new column to check if the date is work day or not
3. Connected with Date table
4. Used COUNTROWS