RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Creating a Table in Power BI Using DAX Table Constructor

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days of learning about DAX. Let’s Read more about Creating a Table in Power BI Using DAX Table Constructor[…]

Text Classification in AI Builder

  Text classification is the fourth model in AI builder. But what is text classification and how we can use it for our data? Text classification or text tagging or text categorization is about organizing and grouping text based on their concepts. We are able to group the text and put a predefined tags/ label Read more about Text Classification in AI Builder[…]

Why My Values are Not Showing Correctly in Power BI?

I have written previously about what is a fact table, and what is the dimension table, and how they relate to each other in a Power BI data model. However, still I see when people use these tables in their model, they get ambiguity of what table should be used for what, and if they Read more about Why My Values are Not Showing Correctly in Power BI?[…]

Change the T-SQL Script of a Power BI Table without Add/Remove from the Model

If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I’m talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the Read more about Change the T-SQL Script of a Power BI Table without Add/Remove from the Model[…]

Generate Random List of Numbers in Power BI Dataset Using Power Query

I’ve been asked from one of my friends who were trying to create a random dataset for his presentation. There is a great and quick way that you can create a random list of numbers in Power BI using Power Query. In this short blog post, I’ll explain how to create this random list. You Read more about Generate Random List of Numbers in Power BI Dataset Using Power Query[…]

Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual

I have previously written how to create a ragged hierarchy, which can be used for organization hierarchy or chart of accounts or similar scenarios. A ragged hierarchy is a hierarchy with un-even number of levels. In a parent-child scenario of organization hierarchy, for example, the CEO is the highest level of the organization, so won’t Read more about Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual[…]

New component of Azure ML Service – Visual Interface

Azure ML services has been introduced for a while, however in the last Microsoft Build, the visual interface of azure ml service has been introduce that has so much similarity to Azure ML Studio. however there are some difference between them as the created experiment in visual interface be shown in the Assets section as Read more about New component of Azure ML Service – Visual Interface[…]

Only Get the Last Few Periods of Data into Power BI using Power Query Filtering

Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only Read more about Only Get the Last Few Periods of Data into Power BI using Power Query Filtering[…]

Power BI Training Self Assessment: What Training Path Should I Take?

You want to see which Power BI training option is good for you. You want to see should you start from the beginning or focus on a specific component of Power BI? This is the question that I often get asked when people come to me and asking about bespoke training for their teams. Here Read more about Power BI Training Self Assessment: What Training Path Should I Take?[…]

Some Methods for Calculating Quarter in DAX for Power BI

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open Read more about Some Methods for Calculating Quarter in DAX for Power BI[…]