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 a...
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] )
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

  • lennox25's avatar
    lennox25
    Post Patron
    3 years ago

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