Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
gpiero
Skilled Sharer
Skilled Sharer

Hard problem for a beginner

I have a table which contain the following columns

 

pic1.JPG

 

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.

pic2.JPG

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?

 

Thanks in advance for your help.

 

If I can...
2 ACCEPTED SOLUTIONS
Sean
Community Champion
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"
)

View solution in original post

@Sean,

 

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

Man Very Happy

 

gpiero

If I can...

View solution in original post

2 REPLIES 2
Sean
Community Champion
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"
)

@Sean,

 

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

Man Very Happy

 

gpiero

If I can...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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