Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

Working with ranges (Numbers/Dates) in Power Query/Power BI - Part 2

by rsaprano on ‎01-30-2018 10:31 AM - last edited on ‎01-30-2018 10:34 AM by MindyJ Frequent Visitor

This 2-part blog post is for working with ranges/bands of numbers in the Edit Queries stage of Power BI. Part 1 covers inexact lookups - looking up a number against a set of bands/ranges and returning the appropriate band which the number sits in. The second part looks at finding overlapping ranges - the scenario where we have two ranges/bands of numbers (rather than having one number and one set of bands) and we want to see the areas of overlap between the ranges.


Join Blog
Interested in blogging for the community? Let us Know.