Use Power Query to Create Custom Column for YYYY MMM

[Anonymous]

Hi, I know it's possible to create a Column in Power BI itself i.e. New Column > Date YM = format([Date],"YYYY MMM")

I've got to do this for multiple fields.  Ideally I would like to be able to do this using the advanced editor to make it easier.

I tried using Text.Format, but this didn't work 😞

[admdc01]

that does not work

[goncalogeraldes]

Hi there @Anonymous ! I was able to get what you need with the following formula:

Table.AddColumn(Previous_Step_Name, "New_Column_Name", each Number.ToText( Date.Year([Date]) ) & " " & Date.ToText([Date], "MMM"), type text)

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[Anonymous]

Hi @goncalogeraldes thanks for the reply.  I don't quite follow this 😞

Tried googling the fields you have used, but not quite working.

= Table.AddColumn(Source,"Enrolment Date Y-M", each Number.ToText(Date.Year([Enrolment Date])) & " " & Date.ToText([Enrolment Date], "MMM"), type text)

[goncalogeraldes]

Using my sample as an example, in the formula above you need to replace the "Previous_Step_Name" with the name of the previous step in your query (located on the right in Applied Steps - in my case the previous step is the "Changed_Type" and as you can its the name on the formula bar). Next you need to replace the [Date] with the name of the Date column you have - beware that it needs to be formatted as a Date Column. And you are good to go 🙂

For additional help, please @ me in your reply!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes