How to convert 1,2,3... to Monday, Tuesday, Wednesday,...

[yumhao]

DirectQuery mode;

I use Weekday(table(date_column)) formula to get the weekday number: 1,2,3,...

How can I get the weekday name? i.e. Monday, Tuesday, Wednesday,...

Many thanks!

[Phil_Seamark · Accepted solution]

Measure = 
VAR 
	myNumber = table[date_col]
RETURN 
	SWITCH(
		myNumber ,
		1 , "Monday" ,
		2 , "Tuesday" ,
		3 , "Wednesday" , 
		4 , "Thursday" ,
		5 , "Friday" ,
		6 , "Saturday" ,
		"Sunday"
	)

[Phil_Seamark]

Or just try 

Weekday  = format(table[date_column],"DDDD")

[yumhao]

the format() formular cannot be used in DirectQuery model....

Thanks anyway!

[Phil_Seamark]

Hi @yumhao

Is your source data an SQL Server?

[yumhao]

My data source is Azure SQL DB, fyi.

Thanks!

[Phil_Seamark · Accepted solution]

Can you modify the SQL you use to get your data and use T-SQL function?

[yumhao]

That's the last solution if i cannot make it in PBI lol.

Thanks!!!

[Phil_Seamark · Accepted solution]

Measure = 
VAR 
	myNumber = table[date_col]
RETURN 
	SWITCH(
		myNumber ,
		1 , "Monday" ,
		2 , "Tuesday" ,
		3 , "Wednesday" , 
		4 , "Thursday" ,
		5 , "Friday" ,
		6 , "Saturday" ,
		"Sunday"
	)