Latest Power BI and AI articles from RADACAD team
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![…]
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 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[…]
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[…]
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[…]
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[…]
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[…]
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[…]
In the last post different ways of creating custom, visuals have been explained. In this post, I will show how to use Charticulator for creating a custom visual in Power BI. As mentioned, first navigate to the below link: https://Charticulator.com Next, you need to click on the Launch Charticulator. This will navigate you to the Read more about Introduction to Charticulator: Create Custom Visual – Part 1[…]
There is always a need to extend the usage of visuals in Power BI. There are multi ways to do it first using First Option: Using Standard Panel Easy to use and available all the time all tested and reliable Read more about Create Visual/Custom Visual for Power BI: Different Approaches[…]