RADACAD Blog

Latest Power BI and AI articles from RADACAD team

What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?

For the world of Power Apps users, the Common Data Services (CDS) might be more understandable, however, in the world of Power BI users, we still have many who don’t know what it is and what is the use cases of it. So I thought better to write about it in this article, and explain Read more about What is Common Data Service (CDS) and why it is important for you if you use Power Apps or Power BI?[…]

Learning About Power BI at Microsoft Ignite 2019 North America: Reza’s Sessions

If you are at Microsoft Ignite 2019 in Orlando, I have five streams of Power BI for you to watch; three sessions, and two podcasts. All on Power BI subject. If you are attending Ignite in person, I am more than happy to see you there. Otherwise, you can watch these sessions via live streaming. Read more about Learning About Power BI at Microsoft Ignite 2019 North America: Reza’s Sessions[…]

Key Influences Visual: Expand By Fields

  In the previous article, I have explained what is the key influencers visual and how it works. Later the count and impact have been explained in the other Post. Initially, Key Influencers visual just has two data fields: Analyze and Explained by the Analyze fields, analyse the data based on row by row, so Read more about Key Influences Visual: Expand By Fields[…]

Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX

If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple function to use to create a list. In this article, I’ll explain how you can use this function. Read more about Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX[…]

Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX

In Power Query, there is an easy way to use Duration and get the number of days, hours, minutes and seconds from it. However, sometimes you need this calculation to be dynamic as a measure in DAX. I had that requirement too. And I wrote a simple DAX calculation which will give you the result. Read more about Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX[…]

Using DataTable DAX Function for Creating Structured Table in Power BI

In another blog article, I explained how easy is to use table constructor in DAX to create a data table fast in Power BI. However, that method has some limitations, such as not being able to name columns or set their data types. In this blog post, I’ll explain about DataTable function in DAX which Read more about Using DataTable DAX Function for Creating Structured Table in Power BI[…]

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?[…]