Forum Discussion

santoshrnath's avatar
santoshrnath
Helper I
9 years ago
Solved

Power BI Desktop - Day Name Issue

Hello I used the Day function in Power BI desktop to know the day name.   Format (DAY(Date), "dddd")   But the day shown in wrong. 03rd Feb 2017 is Friday, but it is showing Tuesday. Why is this ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Well. I'm not a DAX-expert, but DAY(date) gives you 3 (for February 3), and the datevalue of 3 in Power BI is Tuesday, January 2, 1900.

     

    I guess you should remove the DAY() part from your formula, so it will read something like =FORMAT([Date], "dddd")

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Well. I'm not a DAX-expert, but DAY(date) gives you 3 (for February 3), and the datevalue of 3 in Power BI is Tuesday, January 2, 1900.

 

I guess you should remove the DAY() part from your formula, so it will read something like =FORMAT([Date], "dddd")

  • eeaglehouse's avatar
    eeaglehouse
    New Member
    8 years ago

    Here's the reason the accept answer works: DAY() returns the day of the month as an integer between 1 and 31. WEEKDAY() is what was the original poster was looking for, returning a day of the week as an integer between 1 and 7 (Sunday through Saturday). FORMAT() can extract information directly from a date value, which is why neither of the other two functions were needed.

  • santoshrnath's avatar
    santoshrnath
    Helper I
    9 years ago

    Thank you. It resolved the issue.