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.
I wanted to data as month and year. I followed these instuctionsin an old post:
Solution:
Add a Year Column: FieldYear = YEAR(Date)
Add MonthColumn: FieldMonth = MONTH(Date)
THEN ADD SORTORDER column using the two extra columns created above and in this order : SortOrder = CONCATENATE(FieldYear,FieldMonth)
(found that solution here : Link)
That kind of works with ONE exception (see image )
You can see where the month has is January ( represented by a 1 ) it is in the wrong month order.
The answe ( I think ) is to format the month number as 01 rather than 1.
Any idea How do you do this? Or is the more efficent way to do the entire thing?
Kind regards,
Steam Bucky
Solved! Go to Solution.
I found the term i was looking for "Leading Zeros - you can add them by using this format funsction: FORMAT(Table[Col],"00")
This would make "1" into "01"
I found the term i was looking for "Leading Zeros - you can add them by using this format funsction: FORMAT(Table[Col],"00")
This would make "1" into "01"
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |