Forum Discussion
santoshrnath
Helper I
Helper IPower 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 ...
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
Community Champion
Community ChampionWell. 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")
santoshrnathHelper I
Helper IThank you. It resolved the issue.