cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anilp Regular Visitor
Regular Visitor

Day Name & Week Number from Date Column

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
aavilap Regular Visitor
Regular Visitor

Re: Day Name & Week Number from Date Column

Hi, 

Try using the following formula:

 

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

 

Hope it helps!

Regards

View solution in original post

4 REPLIES 4
Highlighted
aavilap Regular Visitor
Regular Visitor

Re: Day Name & Week Number from Date Column

Hi, 

Try using the following formula:

 

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

 

Hope it helps!

Regards

View solution in original post

Super User
Super User

Re: Day Name & Week Number from Date Column

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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





anilp Regular Visitor
Regular Visitor

Re: Day Name & Week Number from Date Column

Hi @aavilap

 

I tried it and it works 

 

Thanks for the help 🙂 

qwertzuiop Regular Visitor
Regular Visitor

Re: Day Name & Week Number from Date Column

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

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)