cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Extract Month and Year from DateTime field to get MMM-YY

Hi,

 

That should be a DAX formula.  Click on the Data Tab in the black bar on the left hand side and then click on Calculated column formula.  Write this formula in the relevant table

 

=FORMAT([Date 2],"mmmm")

 

Hope this helps.

vippankapoor Frequent Visitor
Frequent Visitor

Re: Extract Month and Year from DateTime field to get MMM-YY

Hi Ashish, BIG Thanks for the help. This worked. 

 

One additional challenge i faced is that resultant measure from formula suggested is set up as "Text" field.  I am not able to sort the chart based on calendar months. 

 

Thanks again for guidance and help !!

 

 

Super User
Super User

Re: Extract Month and Year from DateTime field to get MMM-YY

Hi,

 

You are welcome.  Please just Google for "Sort months in PowerBI desktop".  Read the answer by mfhussain here - https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/td-p/9237

ranwar Occasional Visitor
Occasional Visitor

Re: Extract Month and Year from DateTime field to get MMM-YY

This does not work on Direct Query model

kkk333 Frequent Visitor
Frequent Visitor

Re: Extract Month and Year from DateTime field to get MMM-YY

What if I have issue.PNG

is the case and we need to sort using the month, meaning all the vlaues from each month, if I am not wrong , I need to create a measure for that but could anyone guide me a bit on this , how I will do it  ?

kausdutt Frequent Visitor
Frequent Visitor

Re: Extract Month and Year from DateTime field to get MMM-YY

I have three months: Feb, Mar, Apr but its showing in alphabetical order: Apr, Feb & Mar

 

How shall I resolve this issue?


@Ashish_Mathur wrote:

Hi,

 

Try this

 

=FORMAT(Data[Date],"mmm-yyyy")

 

Hope this helps.


 

Super User
Super User

Re: Extract Month and Year from DateTime field to get MMM-YY

Hi,

See my post data 6 MArch 2019.  I have shared a link there.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 248 members 2,814 guests
Please welcome our newest community members: