Stuck getting the right Holidays For my Calender Table

[Anonymous]

Hello,

I am having trouble figuring out how to get the right Holidays in my DAX Calender Table. I can get the Holidays just fine but can't figure out how to do this. I need to make the holidays actualy fall on Friday if the holiday was on Saturday or a Monday if the holiday was on a Sunday.

I was wonderng if anyone could help me out with this?

Thanks

[Greg_Deckler]

Can you supply sample data on your holidays?

[Anonymous]

Here is a picture of the Holidays:

[Anonymous · Accepted solution]

Hi,

You can create a new calculated column name: "Revised Holiday" with formula:

Revised Holiday 
= IF(WEEKDAY('Date'[Date],1) = 1, 
                                 NEXTDAY('Date'[Date]),
   IF(WEEKDAY('Date'[Date],1) = 7, 
                                 PREVIOUSDAY('Date'[Date]),
                                 'Date'[Date]))

I hope this help.

[Anonymous]

Thank you very much!