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")

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

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's avatar
santoshrnath
Helper I
9 years ago

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.