Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Custom Visuals Ideas will be in read-only beginning Friday, Feb. 28 as we prepare to move these ideas to the new Fabric Ideas.

Shinooj

Need to Add Business Dates to a Date

Submitted by on ‎05-20-2024 03:29 AM

I am Having A Date Field and I have put that in a Slicer , and I have a Bunch of Events and That needs to be calculated based on the Date selection done by user , in the Below Format Events and the Date . Please find the below .
Note : The Events Date needs to be calculated Excluding Weekends and Holidays.

Date Table 

Date
01/01/2024
01/02/2024
01/03/2024
01/04/2024
01/05/2024

 


user Select the Date From above Table

Expected Output (Event Date should Exclude Weekends and Holidays)

 

Event NameEvent Date
Event 101/05/2024
Event 201/04/2024
Event 301/12/2024
Event 401/19/2024


Any Help is Appreciated , I was Struggling from last few Days .

Status: New