topic [beginner] Select a range of numbers in a column in DAX Commands and Tips

[beginner] Select a range of numbers in a column

estt — Thu, 16 Feb 2023 19:21:40 GMT

Hello, i ve tryng to filter the column and its been a hard time. I have just 1 column and i need to filter this column between two numbers.

i need to make a new column getting the numbers of this column between -8 and 8 .

Ex.

-11

the new column will be only 6 and 4 excluding -11 and 10

Greg_Deckler — Thu, 16 Feb 2023 19:47:26 GMT

estt Try:

New Column = VAR __Column = [Column1] VAR __Result = IF(__Column > -8 && __Column < 8, __Column, BLANK()) RETURN __Result

estt — Thu, 16 Feb 2023 19:59:47 GMT

It worked man, thanks!