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
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi im_newbie_123 ,

     

    To add a custom column as below.

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

     

     

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