If nextday is holiday then return next working day

[Jagtar0001]

I'm working on a project where client has requested me to work on 2 things.
I have 2 columns 1st is BOOKED and BURN. If today is friday then BOOKED value will be for friday and BURN value for Monday, if not then today() +1,(I have achieved this). But client also wants to check holiday. suppose, on i'm checking report on 25th, and 26th is my holiday, then BOOKED will be for 25th and BURN for 27th(i.e dax has to skip holiday), how to make a dax to check if nextday is holiday or not. I have created a holiday column.

for now I'm using below DAX to skip weekend, please help me to skip holidays as well

Telecast_Testing = if('BIReportDB VW_BIReport'[Day_Name] == "Friday",if('BIReportDB VW_BIReport'[spot_date] >=1 && 'BIReportDB VW_BIReport'[spot_date]<= TODAY()+3,'BIReportDB VW_BIReport'[Spot Amount]/ 10000000,0),if('BIReportDB VW_BIReport'[spot_date] >=1 && 'BIReportDB VW_BIReport'[spot_date]<= TODAY()+1,'BIReportDB VW_BIReport'[Spot Amount]/ 10000000,0))

[v-easonf-msft · Accepted solution]

Hi， @Jagtar0001 

You need to manually import a calendar table that contains the ‘IsWorkingDay’ column. This column identifies all working days and non-working days (including holidays).

Based on this  calendar table you can easily skip non-working days.

Related thread:

https://community.powerbi.com/t5/Desktop/Problem-of-holidays-in-the-working-days/m-p/1965268 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Jagtar0001 , check my blog on Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...