Calculate Days Of Zero Stock – Power BI Inventory Management Insights

Calculate Days Of Zero Stock - Inventory Management Insights wPower BI

I’m going to go over a unique piece of analysis here concerning Power BI Inventory Management. This idea came from a query on the Enterprise DNA support forum. The member wanted to work out how many days there were when the inventory was at zero. This is going to be based on stock movement data.

Continue reading

Three New Releases On Power BI Showcases To Empower Your Business Data

At Enterprise DNA we continue to provide value for your business by developing innovative Power BI solutions. As most of you already know we have created 30+ Showcases, with which you can inspire analytical thinking and development opportunities. In the course of 2 years, we have created high-quality models and reports for you to master

Continue reading

Using ALLEXCEPT To Stop The Cumulative Total From Resetting

I’m going to go through an interesting scenario that you’ll probably land on when you’re trying to run a Cumulative Total inside of Power BI.  A member from the Enterprise DNA support forum posted this query. The member wanted to calculate a running balance like a Cumulative Total. The problem was every time a selection

Continue reading

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this blog post, you’ll learn how to show data from specific time frames as filtered by a date slicer without affecting the overall Cumulative Totals. This is based on a query on the Enterprise DNA Members-Only Support Forum. For sure, you’ll find this quite useful when facing a scenario similar to the example that

Continue reading

Why Using Power BI Variables Is A Better Way To Write DAX Measures

Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin Advice

Using variables is a great way to make sure that your results add up the way they should at the end of your measures. Variables are such a crucial part of writing and solving formulas inside Power BI and I’m going to show you why. Sample Data Visualized In Gantt Chart To showcase the importance

Continue reading