Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution!

One of the most common transformations in Power Query is the Remove Duplicates. This transformation is used in many scenarios, one of the examples, is to create a dimension table with unique IDs in it, so can be used as the source of a one to many relationships to fact tables in the relationship diagram ...

Read More

Linked Entities and Computed Entities; Dataflows in Power BI Part 4

In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. ...

Read More

Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date

I have written some articles about advanced use cases of time intelligence but never wrote about it for beginners. as the time intelligence is an important part of many BI solutions, I decided to write about it from the beginning. In this article, first I explain what time intelligence is, and what are the requirements ...

Read More