Forum Discussion

lennox25's avatar
lennox25
Post Patron
3 years ago
Solved

Create a column filtering values from another column

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

 



Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can add columns like

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

4 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    You can add columns like

    Less than 1000 =
IF ( 'Table'[Unit] > 0 && 'Table'[Unit] < 1000, 'Table'[Unit] )
    • lennox25's avatar
      lennox25
      Post Patron
      3 years ago

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

      • johnt75's avatar
        johnt75
        Super User
        3 years ago

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