blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query

Preview meta tags from the blog.crossjoin.co.uk website.

Linked Hostnames

10

Thumbnail

Search Engine Appearance

Google

https://blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query

Chris Webb's BI Blog: Converting Lists Of Numbers To Text Ranges In Power Query

In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question: can you reverse this? e.g i have a list (1,2,3,5,7,8,9,12,13,14,15) can i convert this to (1-3, 5 ,7-9,12-15) This got me thinking… I was sure it could be…



Bing

Chris Webb's BI Blog: Converting Lists Of Numbers To Text Ranges In Power Query

https://blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query

In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question: can you reverse this? e.g i have a list (1,2,3,5,7,8,9,12,13,14,15) can i convert this to (1-3, 5 ,7-9,12-15) This got me thinking… I was sure it could be…



DuckDuckGo

https://blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query

Chris Webb's BI Blog: Converting Lists Of Numbers To Text Ranges In Power Query

In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question: can you reverse this? e.g i have a list (1,2,3,5,7,8,9,12,13,14,15) can i convert this to (1-3, 5 ,7-9,12-15) This got me thinking… I was sure it could be…

  • General Meta Tags

    11
    • title
      Chris Webb's BI Blog: Converting Lists Of Numbers To Text Ranges In Power Query
    • charset
      UTF-8
    • viewport
      width=device-width, initial-scale=1
    • robots
      max-image-preview:large
    • google-site-verification
      yrvhgtZZu-M6YIaV0ddY9HKGeV07fynzqp5py6YDgog

  • Open Graph Meta Tags

    10
    • og:type
      article
    • og:title
      Chris Webb's BI Blog: Converting Lists Of Numbers To Text Ranges In Power Query
    • og:url
      https://blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query/
    • og:description
      In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question: can you reverse this? e.g i have a list (1,…
    • og:site_name
      Chris Webb's BI Blog

  • Twitter Meta Tags

    5
    • twitter:site
      @cwebb_bi
    • twitter:text:title
      Converting Lists Of Numbers To Text Ranges In Power Query
    • twitter:image
      http://blog.crossjoin.co.uk/wp-content/uploads/2016/11/image_thumb28.png?w=144
    • twitter:image:alt
      image
    • twitter:card
      summary

  • Link Tags

    46
    • EditURI
      https://blog.crossjoin.co.uk/xmlrpc.php?rsd
    • alternate
      https://blog.crossjoin.co.uk/feed/
    • alternate
      https://blog.crossjoin.co.uk/comments/feed/
    • alternate
      https://blog.crossjoin.co.uk/2016/11/24/converting-lists-of-numbers-to-text-ranges-in-power-query/feed/
    • alternate
      https://blog.crossjoin.co.uk/wp-json/wp/v2/posts/4768

Links

86