Supply Chain Management Techniques In Power BI

Managing Your Supply Chain Data w/Power BI - Analysis Techniques

I recently ran a workshop on Supply Chain Management and I want to discuss the key insights from the session. This tutorial can be of great help if you have exposure to this kind of analysis in Power BI. Supply chain management happens within a certain business operation that involves the flow of goods and

Continue reading

Converting A YYWWD Code Into A Date Value In Power BI

How To Convert YYWWD Code Into Date Value In Power BI Query Editor Tutorial

In this blog, we will be discussing how to convert a YYWWD code into a Date Value. This tutorial was based on a response to a query of an Enterprise DNA Support Forum member. The member asked for a way to convert his Confirmed delivery date field, which is in a year, week, and day of

Continue reading

Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor

Turn Calendar Type Layout Into Tabular Format In Power BI Query Editor Tutorial

Analyzing the data that we have can be difficult if it is not correctly arranged. In this tutorial, I will explain how to transform vertical and horizontal repeated data into a tabular format. We do this so that we can have an easier time analyzing it using Power BI. This tutorial was made to address

Continue reading

How To Use The COUNTROWS DAX Function In Virtual Tables

I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see

Continue reading

Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial

One question I got from the Enterprise DNA forum revolves around an addition to the date query table. This addition prevents you from having to manually filter data to the last date every time new data comes in. This can be helpful if you’re working on an ongoing report. I’ll add a link to the

Continue reading