How to extract month name from date

Thanks for quick response 

Month column showing in field list when in enter query editor column not show ??

lavdeep  Calculated columns and Tables that are created under Data Pane can't be visible/accessible under Power Query Editor. In that case, add a new field in Power Query Editor to extract the Month as below using "Custom Column" under Add Column tab.

= Table.AddColumn(#"Changed Type", "NewFieldNameMMM", each DateTime.ToText([DateField], "MMM"), type text)

so if my date is 24/6/2019 and I would like to get a separate column with the month name fro all the dates.

so i should use the below., rite but in this case I am getting error for the word Format sazing its mispellt.

Format([DateField],”MMM”)

Hi,

Yours is a calculated column formula (not a M Language formula).  I think you are trying to write that formula in the Query Editor - do not write it there.