How to create a range from Column values

Question

&nbsp;Hello,I'm looking to create a range out of the values of Lower Limit ColumnThe data is laid out in two columns as shown in Current Data and the Expected outcome is below it.&nbsp;&nbsp;&nbsp;Current Data:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Expected Outcome :&nbsp;&nbsp;Thank you,

vicky_ · Answer

Range (calculated) = 
var nextValue = CALCULATE(MIN('Table'[Range]), FILTER(ALL('Table'), 'Table'[Range] &gt; EARLIER('Table'[Range])))
return IF(nextValue &gt; 0, 
    'Table'[Range] &amp; " - " &amp; nextValue,
    "&gt; " &amp; 'Table'[Range]
)You can try something like the above

anonymous · Answer

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.&nbsp;&nbsp;&nbsp;

ashish_mathur · Answer

Hi,
You should ideally be creating this as a calculated column formula in the Table (not as a measure).&nbsp; Are you OK with my approach?

anonymous · Answer

I tried this as Calculated column, range is not accurate. Check out my screenshot

ashish_mathur · Answer

If you are OK with my approach of creating a calculated column formula rather than a measure, then share the download link of the PBI file.

Forum Discussion

How to create a range from Column values

5 Replies

Related content

Create columns group

Create measure to return value from column when condition met for two other columns

Splitting Column values

Check column for similar values

Matching Column Values