Custom column week day

[shaunparsons66]

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 the day of the week that date values falls on. For example, 'Monday', 'Tuesday' etc.

I have tried to do this using online tutorials, but to no avail. It always tells me that whatever function I use (for example, 'FORMAT') is not recognised.

To be clear, I'm trying to do this in Query Editor by selecting 'add custom column' and then punching in a formula into the box.

Thanks!

[amitchandak · Accepted solution]

@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