Latest Power BI and AI articles from RADACAD team
I have a Power Query script that I usually use in any Power BI solution that needs time-based analysis. However, I never had a chance to publish it here for everyone to use. So here it is. A friend’s question about a time table reminded me that it is good to publish this to the Read more about Script for Creating TIME Table in Power BI with Hours, Minutes and Seconds Buckets[…]
Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters, Read more about Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer[…]
If you have a lot of text in a table visual in Power BI and want to search to find all texts with a specific character in it, I have a solution for you. You can have an alphabet slicer and use it to filter the table visual, the trick is to combine it with Read more about Search in Power BI Table Visual Using a Slicer For Contains Character Criteria[…]
In the last post, I have explained how to use text recognizer fo the aim of detecting the text in a picture using the AI builder in Power Apps. In this post and video, you will how to call it in Power Automate and extract the text from an image that is located in Onedrive Read more about Power Automate for OCR[…]
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[…]