Forum Discussion
Solved
Datediff with filter
Good morning, I have a table with a calendar, a column with the dates and a column with the number 1 for the days the company is open and 0 for the days the company is closed.
I have another table ...
Joao_C_Faria , id start date and end date are column in same table :Production, you can create a column in Production
new column = countx(filter(DateCalendar, DateCalendar[Date] >= Production[Start Date] && DateCalendar[Date] <= Production[End Date] && DateCalendar[Workday]=1),DateCalendar[Date])
else you have to take a measure approch
How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA
The number 1 in the calendar table represents the company being open, and it's in text format, I tried to do "1", but it didn't work either.