topic Re: Get Days of the week from number 1 to 7 in DAX Commands and Tips

Get Days of the week from number 1 to 7

driplytics — Wed, 06 Jul 2022 14:20:24 GMT

My dataset has no date column, but contains Dayofweek from Number 1 to 7.

I want to Create a Column that Returns Monday to Friday instead.

I had to use IF then Function (like shown in the image below) to get this. But i Know there is a better and more efficient way to get this using a simple Dax formula.

Probably, takes the Number like 1 and Return Monday in a column. i would appreciate if i could get your suggestions

Re: Get Days of the week from number 1 to 7

tamerj1 — Wed, 06 Jul 2022 14:44:20 GMT

driplytics

You can use SWITCH function

Re: Get Days of the week from number 1 to 7

v-jianboli-msft — Mon, 11 Jul 2022 07:10:42 GMT

Hi driplytics ,

As tamerj1 mentioned before, you can use switch like this:

Weekday = SWITCH ( [DayOfWeek], 1, "Monday", 2, "Tuesday", 3, "Wedensday", 4, "Thursday", 5, "Friday", 6, "Saturday", 7, "Sunday" )

Output:

Also, you can create a new table like this:

Table = SELECTCOLUMNS ( CALENDAR ( TODAY (), TODAY () + 6 ), "Weekday", FORMAT ( [Date], "dddd" ), "DayOfWeek", WEEKDAY ( [Date], 2 ) )

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.