Forum Discussion
Helper IIIConcatenate labels in matrix
Hi DM_BI ,
Do you want to get the output below?
If it is your case, you could create with date hierarchy (Month-Day )in matrix.
If you still need help, please share your data sample so that we could help further on it.
Best Regards,
Cherry
Resident RockstarHi DM_BI ,
Sorry for the delay.
We could use the feature sort by column to achieve your desired sort.
Firstly, you need to create an Index column based on the order.
Then sort the month column by index column under data view like below.
Hope this can help you.
Best Regards,
Cherry
Helper IIIHi Cherry,
Thank you for your answer. I have tried but sorting by number of month doesn't work in my DimDate table because there are several lines (not unique values). Do I really have to create another table with uniques months to be able to sort the months? I already have so many tables in my model.
Thank you
DM
