Latest Power BI and AI articles from RADACAD team
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[…]
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[…]
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[…]
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[…]
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[…]
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 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[…]
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?[…]
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[…]
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[…]