Day Name & Week Number from Date Column

[anilp]

Hi All,

I have a column in the table from data base called DATE

I need to Extract Week Number & Day Name from the Date Column in Power BI 

1. I tried using this formula 

Weekday Name = WEEKDAY(Glance[Date - Copy], 2) this is giving me weired results 

573 

1263 

1905

2464 

Where I'm looking for Monday , Tuesday , Wednesday 

I don't know what's wrong or I need some help in extracting these 2 columns as I have to create Chart Base on Week Numbers in a Month and then drill down to particular Day.

Help me, please

Thanks,

Anil 

[parry2k]

WEEKDAY function return the week day number not weekday name.

Make sure when you dropped your column WeekDay Name in a visual, you are not aggregating it, and that might be the reason you are seeing these weird value.

[aavilap · Accepted solution]

Hi, 

Try using the following formula:

Weekday Name=FORMAT(Glance[Date - Copy], "dddd")

Hope it helps!

Regards

[qwertzuiop]

Small change at the solution, because there were syntax errors at my formula

Weekday Name = FORMAT (Glance[Date]; "dddd" )

Cheers!

qwertzuiop

[anilp]

Hi @aavilap

I tried it and it works 

Thanks for the help 🙂