Customized evaluation of categories with the DAX function RANKX
In Microsoft Dynamics NAV, also known as Navision or Business Central, the ability to effectively analyze and organize data is critical to the success of a business. A common question asked is: How can you rank categories or items according to a specific metric such as revenue? This is where RANKX comes in, a powerful [...]
Fix Many-to-Many Relationships in Power BI: The Power of Bridge Tables and Bidirectional Cross Filtering
In the world of data analysis and business intelligence, Power BI has established itself as an indispensable tool for turning data into meaningful insights. But Power BI users often encounter a particular challenge: many-to-many relationships. In this article, we'll explore how to solve this problem using a bridge table and implementing Bi-Directional Cross Filtering [...]
