cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Skilled Sharer

## Hard problem for a beginner

I have a table which contain the following columns

I woulld like to calculate the number  of the working days between those days.

I have created a table where  I have defined my calendar according to local Holidays.

The last column contain a logical value that define how to consider that date.

But to be honest I am not able to find a simple way to do it.

Is there a simple solution for a beginner?

If I can...
2 ACCEPTED SOLUTIONS
Community Champion

@gpiero Try this... Let me know if it works.

```Column =
CALCULATE (
COUNTROWS ( 'Calendar Table' ),
ALL ( 'Calendar Table' ),
DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ),
'Calendar Table'[IsWorkingDay] = "Y"
)```
Skilled Sharer

Many thanks. Your solution work perfectly and I have more opportunity to apply it again.

gpiero

If I can...
2 REPLIES 2
Community Champion

@gpiero Try this... Let me know if it works.

```Column =
CALCULATE (
COUNTROWS ( 'Calendar Table' ),
ALL ( 'Calendar Table' ),
DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ),
'Calendar Table'[IsWorkingDay] = "Y"
)```
Skilled Sharer

Many thanks. Your solution work perfectly and I have more opportunity to apply it again.

gpiero

If I can...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors