Power Query | Date (Weekend) to "WE mmdd"

[ovetteabejuela]

Hi,

With M, How can I convert my Week Ending column from a simple mm/dd/yy to something like WE mmdd?

[Anonymous · Accepted solution]

If it hates that, try this instead:

"WE " & Date.ToText([my-date-column],"MMDD")

[Anonymous]

Would this work:

Date.ToText([my-date-column],"WE MMDD")

[Anonymous · Accepted solution]

If it hates that, try this instead:

"WE " & Date.ToText([my-date-column],"MMDD")

[ovetteabejuela]

Somehow, I know about that function however I don't know how to do that exactly like what's the complete command would look like and do I need to add extra column or can I work on the same column and apply this command, but again how do I apply the command if it's the same column that I'm working with.

[ovetteabejuela · Accepted solution]

This is my solution (adding a new column) 

="WE " & Date.ToText(Date.EndOfWeek([date-column], Day.Sunday),"MMdd")

Thanks for the guidance

Note: dd should be in lower case and not DD