Tag: SUMMARIZE DAX

Showing The Last Three Customer Sales Using The TOPN Function

I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. What I want to show you is how to work out the sales from a specific customer, but by only

Continue reading

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

Virtual Tables Inside Iterating Functions In Power BI – DAX Concepts

In this tutorial, I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. Virtual tables are the essential ingredient to creating advanced logic in Power BI. There’s a whole subset of functions inside Power BI that enable you to create these virtual

Continue reading

First Purchase of Customer Insight Using DAX

I have another really unique insight to show to you in Power BI. After this session, you’ll be able to identify a customer’s first purchase and use this data to boost your future sales. By analyzing a trend in terms of the first product that customers are purchasing, you can: (1) change our marketing efforts;

Continue reading