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 this using the advanced editor to make it easier.

 

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

Need Help

4 Replies

  • 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