Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a Matrix with a date-month in string format (text):
I want to sort it in the correct rank (top-down). The rersult should be:
2017-12
2017-11
2017-10
...
2017-1
2016-12
2016-11
...
I can only use this sort options:
Please help!
Many thanks
Solved! Go to Solution.
Maybe what you can do is extract the year from your column with
Year = LEFT(YourColumn;4)
And do the same for your Month
You will have two columns that will be more easy to order
- Quentin
Hi @jup0
Did you try to go to the data tab, click the Modelisation tab and then click on "Sort by column" ?
- Quentin
Yes - but no expected result:
No - this is only 1 table - exported by another user.
I cant change the sql statement and import the data again. - i only got this table.
Maybe what you can do is extract the year from your column with
Year = LEFT(YourColumn;4)
And do the same for your Month
You will have two columns that will be more easy to order
- Quentin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |