Forum Discussion

anilp's avatar
anilp
Helper I
8 years ago
Solved

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 

Need Help
  • aavilap's avatar
    aavilap
    8 years ago

    Hi, 

    Try using the following formula:

     

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

     

    Hope it helps!

    Regards

4 Replies

  • aavilap's avatar
    aavilap
    Helper I
    8 years ago

    Hi, 

    Try using the following formula:

     

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

     

    Hope it helps!

    Regards

    • qwertzuiop's avatar
      qwertzuiop
      Advocate III
      6 years ago

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

      Weekday Name = FORMAT (Glance[Date]; "dddd" )
       
      Cheers!
      qwertzuiop
  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    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.