Create a column filtering values from another column

[lennox25]

Hi, 

I have a table (see below). I need to create another 3 columns filtering as below., so that say for anything >0 and <1000 would only have those values in there (20, 129, 356, 456, 789 and 999 and the remainder blank. Can anyone help me?

1. >0 <1000

2. >1000 <10000

3. >10000

[johnt75 · Accepted solution]

You can add columns like

Less than 1000 =
IF ( 'Table'[Unit] > 0 && 'Table'[Unit] < 1000, 'Table'[Unit] )

[lennox25]

Hi @johnt75  thank you but thats seems to be giving me all the units even past 1000

[johnt75]

are you sure there are no typos? it looks OK to me

[lennox25]

Hi @johnt75  - just tried again and its working! Thank you 🙂