Power BI Desktop - Day Name Issue

[santoshrnath]

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 happening?

[MarcelBeug · Accepted solution]

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]

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]

Thank you. It resolved the issue.

[Phil_Seamark]

Could be something to do with the column you relate to your DAY table?

The formula you are using is ok.

I'm guessing the image you have posted is not from your DAY table but another table.  Can you confirm how this table relates to your DAY table, and how do you build your DAY table?

[santoshrnath]

Hi Phil,

I am not using DAY table, There is a date column in the same table call att_date.

I am using the formula FORMAT(DAY(att_date),"dddd") to get the day value.

I have only one table in the power Bi called att.