RADACAD Blog

Latest Power BI and AI articles from RADACAD team

What Fields to Hide in Your Power BI Solution?

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solution very tidy and clean and easier to maintain. However, you might wonder what are fields that have to be Read more about What Fields to Hide in Your Power BI Solution?[…]

Conditional Column in Power BI using Power Query; You can do anything!

There are many scenarios that you might want to implement a conditional expression. When the conditional expression’s logic is on a row-by-row basis, the best is doing it in Power Query rather than DAX (there are exceptions always), The Add Conditional Column in Power Query is a very helpful option, but often many people find Read more about Conditional Column in Power BI using Power Query; You can do anything![…]

Organize Power BI DAX Measures in Folders

Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Read more about Organize Power BI DAX Measures in Folders[…]

Azure Automated Machine Learning- Part 5

  Azure ML Services has a new component that has been announced a couple of months ago, name Automated Machine Learning. I already start to write about Azure ML Services and Automated ML specifically recently ( which will continue 🙂 ). In Post one to 4 you can find all discussions ( Post 1, Post 2, Post Read more about Azure Automated Machine Learning- Part 5[…]

AI Builder: AI Embedded in Power Apps- Part 2

As mentioned in Part 1, AI Builder is a game changer in Power Apps and Microsoft flow. In this post, I am going to show how you able to access the AI Builder for classification.  to see how to set up your environment check the Part 1. Get Data   to get data, you need Read more about AI Builder: AI Embedded in Power Apps- Part 2[…]

AI Builder: AI Embedded in Power Apps- Part 1

There is a new announcement in the Business Application Summit about AI Builder! So what is AI Builder? Power Apps has been here for a while, it helps none developer people create their own application using Office 365 account, Power Apps has the ability to get data from 100 resources, create an application with multiple Read more about AI Builder: AI Embedded in Power Apps- Part 1[…]

Power BI Shared Datasets: What is it? How does it work? and Why should you care?

I have written a long time ago about sharing a Power BI dataset between reports, in an article written when the feature announced first. Nowadays, if you are in the world of Power BI, you heard a lot about certified datasets, and also shared datasets becoming available across multiple workspaces. In this article, you will Read more about Power BI Shared Datasets: What is it? How does it work? and Why should you care?[…]

Automated Machine Learning: Data Profiling in Azure ML Services – Part 4

In the last 3 posts ( introduction to Azure ML Service, AutoML Environment and how to deploy the models), some demonstration on how we able to access Automated Machine learning and how to deploy a model has been discussed. In this short post, I am going to show a section that helps you to understand Read more about Automated Machine Learning: Data Profiling in Azure ML Services – Part 4[…]

Budget vs. Actual Model in Power BI: Calculations and DAX

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as you slice and dice data in the level of granularity that both tables support, then you don’t Read more about Budget vs. Actual Model in Power BI: Calculations and DAX[…]

Budget vs Actual: Zero Complexity Model in Power BI

When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this Read more about Budget vs Actual: Zero Complexity Model in Power BI[…]