Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Datediff - Ignore weekends

Hi All   I have a very simple visulisation board  for vacations.   Just for some Engineers (source is Asana)   I have a Out of Office Start and an out of office end   OOU=Out of Office   Hold...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Below is my table:

The following DAX might work for you:

Holidy_num = WEEKDAY('Table'[OOU Start],2)

holiday = 
IF('Table'[Holidy_num]<>6 && 'Table'[Holidy_num]<>7 , 
DATEDIFF('Table'[OOU Start],'Table'[OOU End],DAY),
BLANK())

You can create a holiday_num to examine holiday

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.