order month by recent date

[Anonymous]

Hi, 

I am trying to show rolling last 12 and 24 month in one line diagram. 

On the X axis i want to have month with the last full month on the right. 

Somehow I need to order month by recent month.

For example now august :

X.axis    aug sep okt nov dec jan feb mar apr may jun juli

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you to take a look at following blog to know how to calculate cumulative total:

Cumulative Total

For custom order, you can refer to below link to create a custom sort table with 'sort by column' feature to achieve your requirement:

Custom Sorting in Power BI

Regards,

Xiaoxin Sheng