cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Date format issue

Hello All,

 

I have an area chart showing YTD data and I want to display the date as (January,2018  or February,2018 ). I tried Concantenating year and month with comma(,). It gives me the result but its sorted in the Alphabetical order. Please help me to achieve it.

 

This is what I wrote.

 

Test Month year = DateDim_1[MonthName] & "," & DateDim_1[Year]

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Date format issue

@BhavanaGeorge,

 

Yes, the result after concatenated is text format so it will sorted alphabetically. You can change data format from text to date and sort again.

Capture.PNG

 

Regards,

Jimmy Tao

1 REPLY 1
Community Support Team
Community Support Team

Re: Date format issue

@BhavanaGeorge,

 

Yes, the result after concatenated is text format so it will sorted alphabetically. You can change data format from text to date and sort again.

Capture.PNG

 

Regards,

Jimmy Tao