Forum Discussion
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 ...
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")
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")
Thank you. It resolved the issue.