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