Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create a range from Column values

 Hello, I'm looking to create a range out of the values of Lower Limit Column The data is laid out in two columns as shown in Current Data and the Expected outcome is below it.     Current Data: ...
Need Help
vicky_'s avatar
vicky_
Super User
3 years ago

Range (calculated) = 
var nextValue = CALCULATE(MIN('Table'[Range]), FILTER(ALL('Table'), 'Table'[Range] > EARLIER('Table'[Range])))
return IF(nextValue > 0, 
    'Table'[Range] & " - " & nextValue,
    "> " & 'Table'[Range]
)

You can try something like the above

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your reply.

    It does create a range but not accurate, here is my output.

    Looks like the variable needs to be tied to the bucket column, so the range is locked to the adjacent bucket value.