Forum Discussion
MikeSolvesBI
Helper II
Helper IIdefault sort for a field Month Year
Hello, I created a field "Month Year" from the Date field using Date.ToText([Date],"MMM-yyyy"). When I create a table with just this field is sorts alphabetically. How can I get this field ...
Hi MikeSolvesBI
1. Create another column MonthYearNum
MonthYearNum = YEAR([Date])*100 + MONTH([Date])2. Sort your existing column [Month Year] by the newly created MonthYearNum:
3. Sort in the visual based on Month Year as required
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
AlB
Community Champion
Community ChampionHi MikeSolvesBI
1. Create another column MonthYearNum
MonthYearNum = YEAR([Date])*100 + MONTH([Date])
2. Sort your existing column [Month Year] by the newly created MonthYearNum:
3. Sort in the visual based on Month Year as required
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |