Forum Discussion
ForgotID
Advocate I
Advocate IHow 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],",...
It worked. Thank you. Accepting it as solution!
danextian
Super User
Super UserhI 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
)
)
ForgotIDAdvocate I
Advocate IIt worked. Thank you. Accepting it as solution!