How to mention moth name

If you have no date column, it might be easier to:

= Table.AddColumn(PriorStepOrTableName, "Month Name", each Date.MonthName(#date(1, [Month Number], 1)), type date)

 

--Nate

Hi Ramyaajithkumar ,

 

There's a couple of ways to do this. In order of preference:

 

1) If your data has an actual date field in it, then you would create a new custom column a follows:

Date.MonthName([Date])

 

2) If your data does not have a date field in it, then you would need to create a conditional column, something like this:

if [Month number] = 1 then "January"
else if [Month number] = 2 then "February"
else if [Month number] = 3 then "March"
...

 

Pete