Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 with a column with the start of production date and another with the end.
I need to datediff, filtering only the days the company is open, =1.
I can't understand how this dont work:
Time Spent = CALCULATETABLE(datediff('Production'[Startdate],'Production'[Date Time],HOUR),FILTER(DateCalendar,DateCalendar[Workday]=1))
Solved! Go to Solution.
@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.
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.
@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 , create a new column in production
new column = countx(filter(DateCalendar, DateCalendar[Date] >= Production[Start Date] && DateCalendar[Date] <= Production[End Date] && DateCalendar[Workday]=1),DateCalendar[Date])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |