Forum Discussion
Solved
Custom column week day
I have a very simple table with a list of dates in 'date' format. I want to create a custom additional column, that takes the 'date' from the first column, and simply converts it into whatever th...
shaunparsons66 , If you are doing in power query Format will not work
Try this in a new column - Power query/edit query
Date.DayOfWeekName([Date])
https://docs.microsoft.com/en-us/powerquery-m/date-dayofweekname
In DAX
format([Date], "dddd")
Power Query Fy Calendar -https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1
shaunparsons66 , If you are doing in power query Format will not work
Try this in a new column - Power query/edit query
Date.DayOfWeekName([Date])
https://docs.microsoft.com/en-us/powerquery-m/date-dayofweekname
In DAX
format([Date], "dddd")
Power Query Fy Calendar -https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1