Extract specific rows from one column into another

[Marit]

Hi!

I have dataset like this.

IDnr     IDname

2           Per

4           Ole

6           Bert

9           Paul

I want to creat a new colum where I extract the IDname if the IDnr is between 4 and 7. So my new column would look like this:

NewColumn

Ole

Bert

I tried to do this DAX:

NewColumn=CALCULATE(VAULES(Table[IDname]), FILTER(ALL(Table[IDnr] >4 & Table[IDnr] < 7)))

But this doesen't work. Do anyone have suggetions on how to solve this?

Regards Marit

[AlB · Accepted solution]

Hi @Marit 

You want to create a new calculated column in the current table or a new table altogether? If it's the former:

New Column =  IF(Table1[IDnr] >=4 && Table1[IDnr] <= 7, Table1[IDName])

You might have to change the inequalities if you want to exclude 4 and 7 from the range of interest

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Marit]

It was the former. Thank you a lot!