Adding index column base value of a column

[Tevon713]

Hi. 

I have a simple inquiry, want to add new column or measure index based on the column "Days in Query". 

If DaysinQuery is >5 then index = 3, 6-10 then index = 2 and >10 then index =1.  Thank you all.

Example:

Acct	DaysinQuery
1	>5
2	6-10
3	>10
4	>10
5	6-10
6	6-10
7	>5
8	6-10
9	>5
10	>10

Desire result:

Acct	DaysinQuery	OrderingIndex
1	>5	3
2	6-10	2
3	>10	1
4	>10	1
5	6-10	2
6	6-10	2
7	>5	3
8	6-10	2
9	>5	3
10	>10	1

[RemyO · Accepted solution]

First of all i think you want days =<5 but if thats the text then it is so. Just doesnt make sense,

Create a new column:

OrderingIndex = IF('TableName'[DaysInQuery] = ">5",3,

                                IF('TableName'[DaysInQuery] = ">10",1,2))