Forum Discussion
Helper ICreating sequential numbering system based of Today's Month
Hi aausten22
Add to the calculated column which ranks your dates based on month-year:rank_Months =RANKX ('date',RANKX ( 'date', YEAR ( 'date'[Date] ),, DESC, DENSE ) * 100+ RANKX ( 'date', MONTH ( 'date'[Date] ),, DESC, DENSE ),,ASC,DENSE)It will work dynamically as you mentioned that you need
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Helper IWhat I am wanting to achieve is an ordering system that starts with the current month as 1 and numebring backwards to 12
So the column would look like this:
| Date | Order |
| Jun 23 | 1 |
| May 23 | 2 |
| Apr 23 | 3 |
| Mar 23 | 4 |
So when the month changes, the order changes as well. So if we go into July then it would look like the following:
| Date | Order |
| Jul 23 | 1 |
| Jun 23 | 2 |
| May 23 | 3 |
| Apr 23 | 4 |
This would be an automatic change so that visuals and slicers are all the same
Super UserHi aausten22
Add to the calculated column which ranks your dates based on month-year:
It will work dynamically as you mentioned that you need
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly