i have the above column in my dataset table and August to December represent a different year from the January to December and onwards. How do i creat a custom column that sorts the months according to the different years?
Hi, @abelbb
You can try the following methods. In the Power Query, add index column:
Column:
Count = CALCULATE(COUNT('Table'[Month]),FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[Month]=EARLIER('Table'[Month])))Date = DATEVALUE(2023-[Count]&"/"&'Table'[Month]&"/"&"1")Sort = YEAR([Date])*100+MONTH([Date])
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @abelbb
You can try the following methods. In the Power Query, add index column:
Column:
Count = CALCULATE(COUNT('Table'[Month]),FILTER('Table',[Index]<=EARLIER('Table'[Index])&&[Month]=EARLIER('Table'[Month])))Date = DATEVALUE(2023-[Count]&"/"&'Table'[Month]&"/"&"1")Sort = YEAR([Date])*100+MONTH([Date])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
