RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Power BI HR Pattern: DAX Measures for the Last Position to Date: Last Status to Date

One of the common patterns in Power BI is to have a table with different statuses throughout time and then wanting to get the latest status up to a selected date. A simple example of that is to have a table with position(role) changes of employees and then wanting to see their latest position based Read more about Power BI HR Pattern: DAX Measures for the Last Position to Date: Last Status to Date[…]

What a Power BI Hierarchy Is, and How to Use it?

Power BI hierarchies are a useful structure for drill-down and data exploration in reports. A hierarchy can be created simply and can add great value for you as a developer and end-users for better data analysis. In this article and video, I’ll explain what a Power BI hierarchy is and how to create it. Video Read more about What a Power BI Hierarchy Is, and How to Use it?[…]

Book Overview: The Definitive Guide to Power Query in Power BI and Excel

Recently Leila and I published a series of two books under the name of The Definitive Guide to Power Query in Power BI and Excel. Both books are now available in ebook and paperback format on Amazon and Google Play Books. In this blog, I’ll explain some details about the book, the agenda, and who Read more about Book Overview: The Definitive Guide to Power Query in Power BI and Excel[…]

Market Basket Analysis in R Part 3

About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]

Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters

I have written a blog article and explained how Power Query parameters can be used to change the data source in Power BI. Another useful scenario of it is actually to change even the data source itself. For example, you may have two data sources with exactly the same data structure (columns), but different data. Read more about Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters[…]

Power Query Function: Column Value Distribution in Power BI

If you have a table and want to create a report of column value distribution of it in Power BI, This function helps you achieve it. I have explained previously in another blog and video, how to do this process step by step. In this article, I’ll share the code for a custom function that Read more about Power Query Function: Column Value Distribution in Power BI[…]

Creating Column Values Distribution Report in Power BI Using Power Query

I have written about profiling data and the importance of it in Power Query, I also explained how the profiling data can be prepared to create a report in Power BI for the user to understand the data better. And I explained how the error count of that can be added to the report. Another Read more about Creating Column Values Distribution Report in Power BI Using Power Query[…]

Drill Down and Up in Power BI Explained

Power BI works with hierarchies very easily, and there are buttons to drill down and up. However, sometimes, these buttons are confusing for the users. It is essential to know what each drill down/up option is and how it works, not just for developers but also for the end-users. In this blog and video, I’ll Read more about Drill Down and Up in Power BI Explained[…]

Azure Map in Power BI with Layers: Part Three

In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]

Azure Map in Power BI: Part Two

In the last post, an introduction to Azure Map was presented. Azure Map has considerations and limitations as below( that may resolve later as now is in preview) You can use it in Power BI Desktop, Power BI Service, and mobile application But, not available Power BI publish to the web, Embedded and service embedding. Read more about Azure Map in Power BI: Part Two[…]