Forum Discussion

im_newbie_123's avatar
im_newbie_123
Frequent Visitor
6 years ago
Solved

How to create custom column with Power Query editor

Need to create a cusotm column with the combination of Letter P and PreviosuMonth data.

 

Expeceted Output :

P10

P10

P10

P10

 

Thanks in Advance

Need Help

2 Replies

  • artemus's avatar
    artemus
    Microsoft Employee
    6 years ago

    You mean something like:

    "P" & Text.From([PreviousMonth])

    Assuming PreviousMonth is a column that has the number 1 to 12 

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi im_newbie_123 ,

     

    To add a custom column as below.

    ="P" & Number.ToText(Date.Month(DateTime.LocalNow())-1)