cancel
Showing results for
Did you mean:
Frequent Visitor

## Month Sort with Most Current Month on the right in visuals

Within my Date Table I want to build a sort that will allow my visuals to keep the most current month to the furthest right. I have a Timestamp within my model so I was thinking the formula would start with something like:

IF( Month([Date]) = Month('Timestamp') , 12 ,

Sorting Example. If the current Month was May the Sort would go as follows:

January = 8

February = 9

March = 10

April = 11

May = 12

June = 1

July = 2

August = 3

September = 4

October = 5

November = 6

December = 7

Thank you!

1 ACCEPTED SOLUTION
Super User

hi, @PowerBIUser23

could you try to create this calculated column, and sort month name by this column:

``````shiftingMonthSort =
VAR _currentMonthNum =
MONTH ( TODAY () )
VAR _month =
MONTH ( Dates[Date] )
RETURN
IF (
_month <= _currentMonthNum,
12 - _currentMonthNum + _month,
( _currentMonthNum - _month ) * -1
)
``````

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

2 REPLIES 2
Frequent Visitor

This worked perfect Thank you!

Super User

hi, @PowerBIUser23

could you try to create this calculated column, and sort month name by this column:

``````shiftingMonthSort =
VAR _currentMonthNum =
MONTH ( TODAY () )
VAR _month =
MONTH ( Dates[Date] )
RETURN
IF (
_month <= _currentMonthNum,
12 - _currentMonthNum + _month,
( _currentMonthNum - _month ) * -1
)
``````

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Announcements

#### Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors