From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Weeks that start on Monday

Weeks that start on Monday - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Weeks that start on Monday

“

Weekly calculations are immensely helpful in modeling time intelligence within our Power BI models. Power Query and DAX state functions use Sunday as the start of the week and Saturday as the end of the week. But what if we want to start our week on Monday instead? European countries, for example, often start the week on Monday instead of Sunday, and the week ends on Sunday instead of Saturday. We'll need to do calculations to move the start of the week to the most recent Monday instead. Our built-in options for starting our week calculations on a day of the week other than Sunday are quite limited. In Power Query, let's instead calculate an offset for the day of the week and then move each date back accordingly to the most recent Monday. To make it easier to see how these calculations work, let's first calculate the day of the week name as a new column. Now let's add a column to calculate the day of the week number using a function from the Power Query dates family. This returns the…

Contents