Forum Discussion
Solved
Public Holiday - Script
Hello Guys I have a Calendar Table and i would like to add a collumn which contains all public holidays. Is there some script which i can use to generate it? Thanks
Hi avioti,
Current power bi not contains any script to auto generate the holiday calendar table.
You should get a holiday list first, for example:
1. Find out a public holiday list from web, import it to power bi.
2. Create a calendar table and build the relationship.DateTable = ADDCOLUMNS(CALENDAR(DATE(2015,1,1),TODAY()),"Year",FORMAT([Date],"yyyy"),"Month",FORMAT([Date],"mmmm"),"Quarter",FORMAT([Date],"q"),"Week",WEEKNUM([Date],1),"Day Of Week",FORMAT([Date],"dddd"))
3. Add calculated column to check relationship.(holiday = normal holiday + public holiday)
Holiday Tag = IF(ISBLANK(RELATED(Holiday[Federal holiday]))=FALSE(),RELATED(Holiday[Federal holiday]),if([Day Of Week]="Saturday"||[Day Of Week]="Sunday",[Day Of Week],BLANK()))
BTW, you can also share your requirement to ideas.
Regards,
Xiaoxin Sheng
I recommend just finding a web based source, based on your country, where you can pull in a table of dates that are holidays and then merge this with your existing date table.