Create a column with less thatn 50, between 50 and 100, between 100 and 200, more than 500,,, or so

[Nona]

Hi Community, I have a column called [File count]. Value is number of files from [0 to 700].

Based on that [File count] column, I would like to create a new column with the value of

• 0
• Less than 50
• between 51 to 100
• between 101 to 200
• between 201 to 300
• more than 300

Can anyone advise me how to create this kind of column ?

[jppv20 · Accepted solution]

Hi @Nona ,

You can try this as a calculated column:

Range =

IF('Table'[File count]=0,"0",

IF('Table'[File count]<51,"Less than 50",

IF('Table'[File count]>50&&'Table'[File count]<101,"Between 51 to 100",

IF('Table'[File count]>100&&'Table'[File count]<201,"Between 101 to 200",

IF('Table'[File count]>200&&'Table'[File count]<301,"Between 201 to 300",

IF('Table'[File count]>300,"More than 300",

BLANK()))))))

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.

Connect on Linkedin

[Nona]

Thank you very much !!!! it works !

[smpa01]

@Nona try this

Column = switch(true(),table[File Count]=0, "0", 
                       table[File Count]>0&&table[File Count]<=50, "Less than 50",
                       table[File Count]>50&&table[File Count]<=100, "51-100" ,
                       -----------------------------------------------------
                       -----------------------------------------------------
                       table[File Count]>300, "more than 300")