How can I create a column with a range of numbers, instead of just single numbers?

[Anonymous]

I have the following data, which indicates the content inside the pages of a magazine, for example:

As you can see, sometimes the same content covers more than one page, so I would like to create a table in Power BI that shows the range of pages in the first column and the content shown only once in the second table. I don't think this is possible, though.

The result should be this:

[serpiva64 · Accepted solution]

Hi,

Try this

Page range interval =

var MinRange = MINX('Table','Table'[Page range])

var MaxRange = MAXX('Table','Table'[Page range])

var PageRangeInt = CONCATENATE(MinRange,CONCATENATE("-",MaxRange))

return

if (MinRange=MaxRange,MinRange, PageRangeInt)

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Anonymous]

Many thanks for this, but please can you let me know where exactly did you input that formula? 

[Anonymous]

Oh, never mind. I figured it out. 

This actually works like a charm! Many thanks for this!  🙂 

Just one last thing. I did this and the results are now correct, however, the page ranges are not in order. The formula is placing all single pages first and then later all the intervals with more than one page separately. 

Would there be a way to fix this at all? If not it's fine, you already helped me so much anyway!  🙂