Power BI Sequences

Chris Webb shows how to create specific numerical and character sequences in Power BI:

It’s also possible to use this technique to create lists of characters. For example, the expression:

{“a”..”z”}

Returns a list containing all of the lowercase letters of the alphabet

There are a few interesting ways of generating sequences in M, some of them (as the first commenter notes) akin to Python’s sequence methods.

Related Posts

Diagramming Databases With Power BI

Philip Seamark shows how to visualize the relationships between tables using Power BI: The network navigator was another good visual, and if you have an R instance installed on your local machine, you can play with some of the custom R visuals. The catalog views could be used in a similar way to generate power […]

Read More

Web Scraping With Power BI

Imke Feldmann shows how to use Power BI to scrape multiple tables from a webpage: I will present 2 methods here: Append-method: This is the obvious one and is fast for just a few tables. Add-Column-method: A bit more complicated but will be faster for a large number of tables and is also suitable for […]

Read More

Categories

June 2016
MTWTFSS
« May Jul »
 12345
6789101112
13141516171819
20212223242526
27282930