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)

     

     

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)