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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
