In this article, we’ll explore the power of X-Functions like SUMX, AVERAGEX, and more, and how they can transform your data modeling in Power BI. Let’s clarify what we mean and dive into practical examples to enhance your analytics workflows.

Downloadble Resources 

Managing stock levels dynamically is essential for effective inventory management. A crucial aspect of this task involves calculating cumulative quantities to track the balance of products over time. In this example, we have Sales and Purchasing tables, and we aim to create a Matrix visual in Power BI to display the purchased and sold quantities accurately. The ultimate goal is to dynamically track the stock balance (leftover products) at any given point by calculating the difference between cumulative purchases and cumulative sales.

You can download the files related to this article using the following link:
Materials 

Power BI dataflows enable you to connect to, transform, combine, and distribute data for downstream analytics. Some users hope to monitor refresh history and status of dataflows so that they can make refresh plans for datasets that use these dataflows.

In this article, I will introduce three methods to get refresh history of Power BI dataflows.

This is a blog about Workaround to the problem in the dataflow – “We did not recognize the format of your first file”

This is blog about import JSON files from multiple URLs into Power BI Desktop and Dataflow.