topic Re: How can I add the 'ORDER BY' inside that current DAX in a way to SORT ASC? in DAX Commands and Tips

How can I add the 'ORDER BY' inside that current DAX in a way to SORT ASC?

jr3151006 — Sat, 10 Dec 2022 14:40:24 GMT

Hi,

I have a measure which get the dates filtered in a 'DateDimension' table, but as you can see on the imagem below, the order of months are not in the right order.

Q: What is the right 'position' to insert the DAX 'ORDER BY' with 'ASC' parameter?

MeasureSelectedPeriods = IF ( ISFILTERED ( 'DateDimension' ), CONCATENATEX ( VALUES ( DateDimension[Month-Year] ), DateDimension[Month-Year], ", " ), "No period selected" )

########################
Current result obtained
########################

########################
The desired/expected would be:
########################

Re: How can I add the 'ORDER BY' inside that current DAX in a way to SORT ASC?

Greg_Deckler — Sat, 10 Dec 2022 14:41:50 GMT

jr3151006 If those aren't real dates but text, it is going to sort them as if they are text. Perhaps try adding a Sort By column with a real date?

Re: How can I add the 'ORDER BY' inside that current DAX in a way to SORT ASC?

jr3151006 — Sat, 10 Dec 2022 14:43:26 GMT

Hi,

are you talking about to apply order directly on the table field??

Re: How can I add the 'ORDER BY' inside that current DAX in a way to SORT ASC?

Anonymous — Mon, 12 Dec 2022 02:15:29 GMT

Hi jr3151006 ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Year_Month = MONTH('Table'[Date]) &"/"&YEAR('Table'[Date])

2. Create measure.

Measure = var _min=MINX(ALLSELECTED('Table'),[Date]) var _max=MAXX(ALLSELECTED('Table'),[Date]) var _table= FILTER( 'Table','Table'[Date]>=_min&&'Table'[Date]<=_max) var _table1= SUMMARIZE(_table,[Year_Month]) return CONCATENATEX(_table1,[Year_Month],",")

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly