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 =...
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

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