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

Power BI Dot Plot Custom Visual

Devin Knight continues his Power BI custom visuals series: In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes. Dot plots are nice because they tend to be informative while keeping the ink […]

Read More

Power Query: Joining On Date Ranges

Reza Rad shows how to build merge joins between date ranges in Power Query: Customer’s table has the history details of changes through the time. For example, the customer ID 2, has a track of change. John was living in Sydney for a period of time, then moved to Melbourne after that. The problem we […]

Read More

Categories

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