Forum Discussion

Joao_C_Faria's avatar
Joao_C_Faria
Helper I
4 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

     

Joao_C_Faria's avatar
Joao_C_Faria
Helper I
4 years ago
First of all, thank you for availability.

Says the expression references multiple columns. It is not possible to transform several columns into a scalar value.

I send the images as an attachment to make it easier, I changed the name of the columns that were in Portuguese to make it more readable.

Compliments
I need to know the number of business days between startdate and enddate.

Thank you very much.


amitchandak's avatar
amitchandak
Super User
4 years ago

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