Get startedGet started for free

Analyzing trends by day of week

Time series analysis is conducted at various date grains - year, month, week, day. It also involves evaluating trends at different date-derived context such as day of the week.

In this exercise, you will use the WEEKDAY() function to create a new day of the week variable, then analyze trends by city with small multiples.

If you have lost any progress, close any open reports and load 1_2_weekday.pbix from the Workbooks folder on the Desktop.

This exercise is part of the course

Trend Analysis in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise