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 [...]
Power BI Helper: The external tool to support metadata management in Power BI Desktop
Power BI Desktop is a powerful application for creating interactive data visualizations and reports. In complex Power BI projects, especially in conjunction with Microsoft Dynamics NAV, Navision and Business Central, effectively managing and monitoring metadata can be a challenge. In this blog article, we introduce you to "Power BI Helper", an external tool specifically designed [...]
Handling multiple date values in Power BI with DAX-Measure and a single date dimension table
When analyzing data in Power BI, you may need to work with multiple date dimensions. In some cases, you may want to use only a single date dimension table and associate the different date types such as sales date, delivery date, and due date with it. In this blog article, you will learn how to use a single date dimension table and the USERELATIONSHIP [...]
Power BI: How to display a web page dynamically within Power BI using HTML5 Visual?
Power BI offers numerous options for visualizing and analyzing data. But did you know that you can also dynamically display a web page within Power BI? Using the HTML5 visual and an iFrame, you can seamlessly integrate external web pages into your report and link them to your data. In this blog post we will show [...]
Evaluate Corona infections in PowerBI
Here is an example of how the current Corona figures can be evaluated in Power BI. The numbers update daily based on the data published on corona.rki.de. The evaluation has 4 different pages at different aggregation levels. By clicking on the bars, you can filter everything else on each page. The corresponding PowerBI file can be [...]
