Posts filed under Intermediate

Ranking by Multiple Columns (Guest Post by BI Elite)

Video by: Parker Stevens

BI Elite YouTube Channel

Today's video is a guest post from Parker over at BI Elite. Parker has generously agreed to do a guest video for my channel, where he'll explain how to use DAX to create a ranking based on multiple columns. So give it a watch and see how quickly and easily it can be done.

Posted on January 8, 2019 and filed under Intermediate, Power BI.

Extracting Multiple Tables From A Power Query Combine Folder Source

Video by: Reid Havens

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

Posted on December 4, 2018 and filed under Intermediate, Power BI, Power Query.

Power BI Feature Highlight: Many-to-Many Relationships

Video by: Reid Havens

In this video you'll learn about an exciting and recently announced feature for Power BI Desktop...MANY-TO-MANY Relationships. You'll see how easy it is now to connect two tables with non-distinct keys together using this new feature.

Posted on July 25, 2018 and filed under Intermediate, Power BI Features, Power BI.