Latest Power BI and AI articles from RADACAD team
There are many time intelligence functions in DAX, and each of those is helping in aspects of analyzing data on dates. There are two functions which work very similar to each other but have a bit different usage; DatesInPeriod, and DatesBetween. In this post, I will show you what is the difference between these two Read more about DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI[…]
One of the most common requirements in any reporting solution is the ability to drill through from master page to the details page and see the details of an item or category. In this post, I will explain how this feature is simply possible in Power BI, and what are things to consider when you Read more about Master Detail Design with Drillthrough Filter in Power BI[…]
Power BI Helper is getting new features every time, and this time, we got some exciting features; You can now get your M (Power Query script) code beautified and colorful with version 4.0 of Power BI Helper. We also get the row-level security information exposed through the Helper application. Both information above will be now Read more about Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0[…]
Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman. To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer Read more about Fun with DAX – Mission Impossible[…]
Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to Read more about Find Mismatch Rows with Power Query in Power BI[…]
I work with Power Query transformations every day these days, and I want to share one simple, but critical caution with you. If you use Power Query a lot, this tip can improve the performance of your transformation significantly. The number of steps that you add in a query counts in the performance of your Read more about Watch Your Steps! Power Query Performance Caution for Power BI[…]
One of the biggest holes in DAX today is the lack of a native function that allows you to convert a decimal number to its roman number equivalent. Excel has a ROMAN() function so I thought it was about time to share one approach to converting decimal numbers to Roman. I can feel a collective Read more about Quick DAX : Convert to Roman Numerials[…]
In the last post, I have shown how to create a simple Bot. In this post, I am going to show how to create a Question and Answer Bot and embed it in a website. To start you need to create a Web App Bot in Microsoft Azure with Bot Template as Question and Answer. After creating the Read more about Microsoft Bot -Part2: Create a Question and Answer[…]
Using Microsoft Bot in applications and report make them more agile and interactive. there are many ways to use Microsoft Bot. In this posts and the next one, I will explain how to create a Microsoft Bot in Azure and then embed it in your PowerBI and messenger like Facebook messenger or Telegram. How to Read more about Microsoft Bot -Part1: Create a sample[…]
I have front row seats at the keynote that will begin shortly. As features and announcements are made, I will update here. The room is massive and filling fast. I’m sitting with some true legends in right by the stage and there is an electric buzz in the air. And we are underway. Power BI Read more about Microsoft Business Applications Summit – 2018 Keynote (Live Blog)[…]