RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Compare Period Over Period Breakdown in Power BI Using the Waterfall Chart

The Waterfall chart is a good visualization to show you changes on value over a sequence, The sequence can be time, or date or workflow steps, etc. There is also an ability in this chart that may not be visible to everyone, and that is the breakdown option of this chart. You can use the Read more about Compare Period Over Period Breakdown in Power BI Using the Waterfall Chart[…]

Currency Exchange Rate Conversion in Power BI with Live Rates – Part 2

In the previous part of the currency exchange rate conversion, I provided a function script that you can use to get live rates using a free API. In that part, you learned how you can create a table in dataflow using live rates. In this part, I will show you how you can use the Read more about Currency Exchange Rate Conversion in Power BI with Live Rates – Part 2[…]

Currency Exchange Rate Converter Power BI Function – Part 1

If you ever need to convert amounts from one currency to another, you face the challenge that currency rates are not constant. They change every day. You either need to keep an up-to-date table of all new currency rates and use that in your Power BI solution, or use a function that gets the rate Read more about Currency Exchange Rate Converter Power BI Function – Part 1[…]

Sort a Column with a Custom Order in Power BI

I have previously written about how to sort a column by another column, and I used Month Names as an example. However, still, many are unaware that the same technique with slight modifications can be applied to any other columns. You can have a text column in your slicer (product category for example), and sort Read more about Sort a Column with a Custom Order in Power BI[…]

Caution When Using Variables in DAX and Power BI

I have written another blog post about variables previously and explained how useful variables are. Variables in DAX are helpful in both readability and also the performance of your code. However, there are scenarios that you have to be careful when you use variables. Because variables are stored, they might return a result that is Read more about Caution When Using Variables in DAX and Power BI[…]

Business Card Reader Automation with AI Builder, Power Automate and Power Apps

AI Builder brings a huge change to creating smart self-service Applications. In this post we are going to see how to create a smart application that able to read the Business Card content and extract them, then import them using Power Automate to the Outlook contact list. Creat Business Card Reader using Power Apps and Read more about Business Card Reader Automation with AI Builder, Power Automate and Power Apps[…]

Write Conditional Statement Using SWITCH in DAX and Power BI

Conditional expressions are one of the most commonly used expressions in any language as well as DAX. However, in DAX, if you have multiple IF THEN expressions, there is an easier way of doing it; using a function called SWITCH, this blog is about how you can use switch function in DAX and Power BI Read more about Write Conditional Statement Using SWITCH in DAX and Power BI[…]

Add or Edit Columns When Importing Data from Analysis Services into Power BI

If you use SQL Server Analysis Services as a data source for Power BI, you have two types of connection; Live Connection or Import Data. If you use Import Data, you can select columns and measures to be imported into Power BI. However, what if you want to add more columns to it, or edit Read more about Add or Edit Columns When Importing Data from Analysis Services into Power BI[…]

Text Classification using AI Builder inside Power Automate (Microsoft Flow)

Text classification is one of the important tasks for the aim of classifying the texts based on the allocated tags. In the previous blog, the process of how to create Text classification in the Power Apps using AI builder has been explained, In this Blog Post, you will see how to use the created Text classification Read more about Text Classification using AI Builder inside Power Automate (Microsoft Flow)[…]

All in One: Script to Create Date Dimension in Power BI using Power Query

I have written multiple blog posts about how to create a date dimension using Power Query, however, the purpose of those blog posts was to teach you how to do it yourself, learn the process and also build the date dimension that you can use. Sometimes, however, you just want to create a date dimension Read more about All in One: Script to Create Date Dimension in Power BI using Power Query[…]