How to quickly add a date table in Power BI
If you use data from systems such as Microsoft Dynamics NAV, its predecessor Navision or the newer Business Central in Power BI, the integration of a date table is often indispensable. It enables deep time-based analysis of your business data. In this article we will show you how to implement this efficiently. 1. why a data table is important: Before we start [...]
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 [...]
