Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated column for number reordering

I have a column with 'recieved month number' and I'd like to find a way to start my first month at number 7.

I thought about a formula to add 6 to any value less than 7 and subtract 6 for any value greater than.

I tried a table with an index colum but that didnt seem to work. Trying to avoid going down the date path!

Thanks

Nic

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous  , 

    Create new column:

    MONTH FILTER = IF( MONTH >= 7 , 1 ,0 )

    Then, you can filter your visuals with this column. Or create a new table with DAX with with filter MONTH FILTER = 1

     

    Let me know if that was helpful

     

    Cheers

    Robin