In Power BI, we will encounter the many-to-many relationships frequently. Typically, when faced with this situation, we always create a bridge table to establish connections and process the data. However, creating a bridge table will involve the calculation of more than three tables, and it may lead to circular dependencies sometimes. As an alternative, in certain scenarios, we can explore using the Cartesian Product to handle the data. Let's look at a sample in the next sections.  

Scenario:
In some cases, we may need to construct a table that contains only those entries that satisfy certain filtering criteria. The purpose of this article is to illustrate how to use the Dax or M function to achieve this function.

Discover how to automatically update your Power BI date filters including Date Slicers and visuals to the latest date from your fact table.