Public holidays in Power BI part 3 – Calculating the first and last Monday

In the previous parts of this series on public holidays we looked at calculating when Easter falls in the year and how to find the next Monday. Now we’ll be trying to find the first and last Monday of a month. Continue reading “Public holidays in Power BI part 3 – Calculating the first and last Monday”

Public holidays in Power BI part 2 – Calculating the next Monday

In part 1 we looked at calculating Easter Day. This time we’ll be looking at New Year’s, Christmas and Boxing day. If these fall on a weekend the public holiday will be the next available working day so we need a way to calculate the next working day. Continue reading “Public holidays in Power BI part 2 – Calculating the next Monday”

Public holidays in Power BI part 1 – Calculating Easter

Public holidays are hugely important when doing any time based analysis. For some businesses it might be a period where they close, for other businesses it could be peak trading.

When entering public holidays into Power BI you could just load in a table of dates from Excel. However this will require more maintenance. The ideal way to deal with public holidays is to have Power BI calculate them for you; then you can just leave the report to follow it’s refresh schedule. Continue reading “Public holidays in Power BI part 1 – Calculating Easter”