Forum Discussion

aausten22's avatar
aausten22
Icon for Helper I rankHelper I
3 years ago
Solved

Creating sequential numbering system based of Today's Month

Currently I have a dataset with a list of months formatted as "MMM YY"   What I am wanting to achieve is a numbering system as a calculated column that will add the numbers 1-12 based on the curren...
Need Help
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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

     

    Link to the sample file 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

 aausten22 

 

you can create a date column in pq then use dax to create a column

Column = DATEDIFF('Table'[Custom],TODAY(),MONTH)+1
 
pls see the attachment below