Latest Power BI and AI articles from RADACAD team
Another service to Microsoft Cognitive Text Analytics API is Text Analytics API, which is about Entity Linking, and Named Entity Recognition (NER). Entity Linking: Entity Linking able to identify the disambiguate the identity of an entity found in the text (for example, determining whether an occurrence of the word Mars refers to the planet, or Read more about Text Entity Extraction in Power BI, Text Analytics Service[…]
If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method Read more about Working with Records, Lists, and Values in Power BI Dataflows[…]
I have previously written a blog post about what the ALL function in Power BI is, and how it helps in working with filters in your report. However, still I get many students confused about how to use this function, which parameter to pass to it. This blog post is explaining that in detail. Why Read more about How to Use ALL in a DAX Expression in Power BI[…]
In the last post, I have explained how to work with Q&A visual . There is a way to define terms for the Q&N visual. There are two main terms Adjective Define an explanation for a column using a Measure. We able to define a measure as adjective for each columns of data. Columns Define Read more about Q&A Visual – Define an Adjective for a Column[…]
There are a couple of useful actions that help a lot in cleaning data; removing digits, or keeping digits and removing everything else. In this short blog article, I’ll explain a simple method to do that using Power Query. Sample Data My sample data table looks like this: Removing Digits I can easily get rid Read more about Remove Digits or Keep them in Power BI Using Power Query[…]
If you have used the relative date slicer and you are not living at a timezone close to UTC, then you have seen that the Power BI Date slicer is not much of a use, because you have to still adjust it with your local time zone. I have previously written a couple of articles Read more about Relative Date Slicer for Your Local Time Zone in Power BI[…]
I have written previously provided an all-in-one script for the date dimension, and also wrote an article about the relative date slicer. However, sometimes you cannot use the relative date slicer (timezone issue can be one example), adding offset columns help to overcome that challenge, and still be able to do flexible relative filtering in Read more about Offset Columns for the Date Table: Flexibility in Relative Date Filtering for Power BI[…]
Working with Power BI and Power Platform dataflows, or using Dynamics in general, might cause you to hear one of these two CDS (Common Data Services), or CDM (Common Data Model). Often there is a misconception about these two, and many people think they are the same. In this article, I’ll explain the difference between Read more about CDS and CDM are Not the Same! Difference Explained[…]
If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. This is a very simple type of slicer to use, but very effective in terms of options that it provides for the user to slice and dice the data. Let’s Read more about Relative Date Slicer in Power BI; Simple, yet Powerful[…]
Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I’ll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are Read more about Fibonacci Sequence: Understanding the Power Query Recursive Function for Power BI[…]