After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is Read more about Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold[…]
In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived Read more about Power BI and Azure ML make them work with Power Query[…]
Here is a technique you might consider if you need to split text down to individual words. This could be used to help count, rank or otherwise aggregate the words in some longer text. The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between Read more about Quick DAX : Word count[…]
I’ve been honored and had the opportunity to have an interview with some great minds in Ignite 2018. Just to mention a few; it was the discussion about all new Power BI and AI features announced at Microsoft Ignite 2018 conference. In this post, you will see the link to all my 14 interviews of Read more about Ignite 2018 Interviews by Reza Rad; Power BI and AI[…]
The latest addition to my recent series of DAX based games is the classic Minesweeper game. This is the game where you are presented with a 9 x 9 matrix of squares. There are 10 hidden mines and you can either step on a square or place a flag where you think there might be Read more about Fun with DAX – Minesweeper[…]
When you work with tables and queries in Power Query and Power BI, you get the option to copy them through these actions: Duplicate, or Reference. It has been always a question in my sessions and courses that what is the actual difference between these two actions. The explanation is simple but very important to Read more about Reference vs Duplicate in Power BI; Power Query Back to Basics[…]
There are many time intelligence functions in DAX, and each of those is helping in aspects of analyzing data on dates. There are two functions which work very similar to each other but have a bit different usage; DatesInPeriod, and DatesBetween. In this post, I will show you what is the difference between these two Read more about DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI[…]
One of the most common requirements in any reporting solution is the ability to drill through from master page to the details page and see the details of an item or category. In this post, I will explain how this feature is simply possible in Power BI, and what are things to consider when you Read more about Master Detail Design with Drillthrough Filter in Power BI[…]
Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman. To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer Read more about Fun with DAX – Mission Impossible[…]
Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]