Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use Power Query to Create Custom Column for YYYY MMM

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 t...
Need Help
goncalogeraldes's avatar
goncalogeraldes
Super User
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      goncalogeraldes
      Super User
      3 years ago

      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