Sequence column based on Day of Week

[joshua1990]

Hi all!

I have a table that has a column with the day of the week: Monday, Tuesday...

Now I would like add a column with a number to be able to order this column in the right sequence.

But I always get an error that this is not possible since there a independencies between both columns.

How can I add a sequence column to be able to order the column?

[Anonymous]

@joshua1990 , use the DAX function WEEKDAY.

[joshua1990]

@Anonymous : This works just with Date columns

[Anonymous]

@joshua1990 , try this for your Calculated Column:

DayOfWeekSequence = WEEKDAY('dimDate'[Date])

In my Date table, it gives me this result:

I can then select the DayOfWeekSequence column to sort the DayOfWeek column:

Is this what you are looking for?

[joshua1990]

Hi, as mentioned I dont have a Date column

I have a text column that contains the day of the week, thats it.

[Anonymous · Accepted solution]

@joshua1990 , oh I see. Try this Calculated Column:

DayOfWeekSequence = 
    SWITCH('YourTable'[TextColumn],
        "Monday", 1,
        "Tuesday", 2,
        "Wednesday", 3,
        "Thursday", 4,
        "Friday", 5
        "Saturday", 6,
        "Sunday", 7
    )

Then set the Sort by Column option for 'YourTable'[TextColumn] to sort by the DayOfWeekSequence column.

[Anonymous]

@joshua1990 , did my solution work for you?