cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lavdeep Frequent Visitor
Frequent Visitor

How to extract month name from date

HI,

 

i have colunm where date format "DD/MM/YYYY" i want to extract only month name like this "MMM" formate "Jan"

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: How to extract month name from date

@lavdeep Please add a new column in Data Pane as below

Month = Format([DateField],”MMM”)


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





lavdeep Frequent Visitor
Frequent Visitor

Re: 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 ??

Super User
Super User

Re: How to extract month name from date

@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)

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





3 REPLIES 3
Highlighted
Super User
Super User

Re: How to extract month name from date

@lavdeep Please add a new column in Data Pane as below

Month = Format([DateField],”MMM”)


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





lavdeep Frequent Visitor
Frequent Visitor

Re: 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 ??

Super User
Super User

Re: How to extract month name from date

@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)

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !