Forum Discussion

ForgotID's avatar
ForgotID
Advocate I
11 months ago
Solved

How to order the months while using CONCATENETX

Hello All,   I am trying to show multiple selected value in a card by using the following DAX. FSC_Periods = CALCULATE( CONCATENATEX(DISTINCT(Metrics[FSC_PERIOD_NAME]),Metrics[FSC_PERIOD_NAME],",...
Need Help
  • ForgotID's avatar
    ForgotID
    11 months ago

    It worked. Thank you. Accepting it as solution!

danextian's avatar
danextian
Super User
11 months ago

hI ForgotID 

 

CONCATENATEX has an optional order by parameter. Ensure that your table has such a column.

FSC_Periods =
CALCULATE (
    CONCATENATEX (
        DISTINCT ( Metrics[FSC_PERIOD_NAME] ),
        Metrics[FSC_PERIOD_NAME],
        ", ",
        CALCULATE ( SELECTEDVALUE ( Metrics[FSC_PERIOD_NAME_SORT] ) ) -- custom sort-by column in your table
    )
)

 

  • ForgotID's avatar
    ForgotID
    Advocate I
    11 months ago

    It worked. Thank you. Accepting it as solution!