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!

bchager's avatar
bchager
Resolver III
11 months ago

ForgotID  It sounds like you need to sort your FSC_PERIOD_NAME by the Date column within your table, which should also be sorted.

ForgotID's avatar
ForgotID
Advocate I
11 months ago

Thank you for your input