RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Create a Table with A to Z Character Values in Power BI Using DAX

I have explained previously that you can use GenerateSeries function in DAX to create a list of number, date or time, or even currency values. However, sometimes you might need to create a list of text values. Such as alphabet; from “a” to “z” lowercase, or uppercase. The good news is that you can do Read more about Create a Table with A to Z Character Values in Power BI Using DAX[…]

Text Recognizer with AI Builder

In this short blog, I am going to show how amazing the text recognizer works in Power Apps and AI Builder. That is one of the new features we have. First, log into to Power Apps with AI Builder features. Then click on the Ai Builder in the left panel and choose the Build, Next Read more about Text Recognizer with AI Builder[…]

Page Navigation Buttons in Power BI

Previously, to create page navigation in Power BI, you needed to create bookmarks, and buttons to action to that bookmark. However, recently, in the last version of Power BI Desktop, the ability to easily navigate to other pages using Buttons in announced. In this short article, I’ll explain how you can use this approach to Read more about Page Navigation Buttons in Power BI[…]

Subscription Pattern in Power BI – DAX Measure for Active Subscribers or Open Tickets For All Dates

One of the common patterns of a data model is the subscription pattern. In this pattern, we have subscriptions (or tickets, or issues, or whatever else you want to call it) open date and close date. The way that this data is stored in a table makes it a bit challenging to get informative insight Read more about Subscription Pattern in Power BI – DAX Measure for Active Subscribers or Open Tickets For All Dates[…]

Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Size of Bins

In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I’ll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Size of Bins[…]

Sentiment Analysis Application: Microsoft Power Automate, Power Apps and AI Builder

Thanks to AI Builder in Microsoft Power Apps and Flow, now we have access to sentiment analysis, Keyword extraction and Language detection inside Microsoft Flow is now available. In this post, I am going to show how to do sentiment analysis inside Power Automate. First What is sentiment Analysis and what sort of analysis we Read more about Sentiment Analysis Application: Microsoft Power Automate, Power Apps and AI Builder[…]

Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Count of Bins

Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Count of Bins[…]

Age Banding in Power BI Using TREATAS DAX Function – Relationship Based on Between

One of the most common types of banding or binning is banding based on a range. Let’s say, for example,  you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship Based on Between[…]

Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function

TreatAs is helpful for filtering, and it doesn’t filter only based on one column, it can filter based on as many as columns you want. One of the challenges in Power BI relationships is creating a relationship based on multiple fields, I have previously explained a method you can use to create a compound key Read more about Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function[…]