Unlike Microsoft Excel, Microsoft Power BI doesn’t have the ability to build custom sorts. However, you can sort one column by another, which is effectively the same thing and easy to implement.

SEE: Follow along in this guide to add a calculated column in Microsoft Power BI. On the other hand, if you’d like Power BI to do this for you, don’t mark the table as a date table.