Tag: Data Analysis

Simple Power BI Transformations For More Optimized Data

I’m going to talk about simple Power BI transformations you can do around the query editor. The query editor allows you to clean up your data and transform it from its rawest form. Although it allows you to do some really advanced transformations, I want to focus on the simple ones you can do. Through

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

Custom Dynamic Segmentation Using DAX In Power BI

In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. Dynamic groups are created when a range of different customers are segmented based on different metrics like sales, margin

Continue reading

Projecting The Current Trend in Your Power BI

In this unique example, I want to show you how to project a historical trend in Power BI and repeatedly project it forward. This particular example came from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world using historical information, which could

Continue reading

How to Maximize The Use of INTERSECT Function – Advanced DAX

The INTERSECT function in Power BI is an advanced table function and you need to understand it better so you can maximize the use of this advanced DAX. But to understand how it works, you need to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within

Continue reading