Sort Days by the Week

[Anonymous]

Hi Community, I'm new to Power BI and would like to get some help on how to do this.

I'll be creating a matrix and I have the dates. However, I would like to sort the days by the week to have a clearer visualization.

I want it to look like the picture below. I need help on how to get the calculations for the highlighted columns.

Thanks Alot!

[lbendlin]

In your data model use a calendar table. In your calendar table have columns for "Name of week" and "is working day".