I am working on a Data Set. I need to ignore the Weekends and USA Public Holidays. I need to build a Master calendar for these dates . For example if you look at the chart on Monday it will show previous day data that is Friday (Not Sat or Sun) or ignore any Holidays.
One thing you may take a look is the function Weekday() where you can get as return, the day of the week for each date record. After getting it, you can use an expression that will not display dates where weekday = 'Sat' or 'Sun'.
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.