Latest Power BI and AI articles from RADACAD team
In the previous article, I explained how you can use GROUPBY function in DAX to create an aggregated table. In this article, I’ll explain how you can use Summarize function for the same purpose. Summarize function gives you more control on how to create your aggregated table with some extra functions. Let’s see how it Read more about Aggregated Table in Power BI with Extra Options – Summarize Function in DAX[…]
There are many different ways you can create aggregations in Power BI, You can do it in the source (using the database t-SQL language), or using Group By operation in Power Query. You can also do it in DAX using some functions. One of the functions that can be used for grouping and aggregation is Read more about Aggregated Table in Power BI – Using GroupBy Function in DAX[…]
I have explained previously that you can use GenerateSeries function in DAX to create a list of number, date or time, or even currency values. However, sometimes you might need to create a list of text values. Such as alphabet; from “a” to “z” lowercase, or uppercase. The good news is that you can do Read more about Create a Table with A to Z Character Values in Power BI Using DAX[…]
In this short blog, I am going to show how amazing the text recognizer works in Power Apps and AI Builder. That is one of the new features we have. First, log into to Power Apps with AI Builder features. Then click on the Ai Builder in the left panel and choose the Build, Next Read more about Text Recognizer with AI Builder[…]
Previously, to create page navigation in Power BI, you needed to create bookmarks, and buttons to action to that bookmark. However, recently, in the last version of Power BI Desktop, the ability to easily navigate to other pages using Buttons in announced. In this short article, I’ll explain how you can use this approach to Read more about Page Navigation Buttons in Power BI[…]
One of the common patterns of a data model is the subscription pattern. In this pattern, we have subscriptions (or tickets, or issues, or whatever else you want to call it) open date and close date. The way that this data is stored in a table makes it a bit challenging to get informative insight Read more about Subscription Pattern in Power BI – DAX Measure for Active Subscribers or Open Tickets For All Dates[…]
The new Azure ML environment contain a Azur Notebook that you able to write the python code there. In this post, I will go through the experiment and see how we can use this environment for the aim of regression analysis. First you need to setup the environment inside azure portal as below, click on Read more about Azure ML Notebooks[…]
In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I’ll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Size of Bins[…]
Thanks to AI Builder in Microsoft Power Apps and Flow, now we have access to sentiment analysis, Keyword extraction and Language detection inside Microsoft Flow is now available. In this post, I am going to show how to do sentiment analysis inside Power Automate. First What is sentiment Analysis and what sort of analysis we Read more about Sentiment Analysis Application: Microsoft Power Automate, Power Apps and AI Builder[…]
Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Count of Bins[…]