Tag: FILTER Function

Calculating Reverse Cumulative or Reverse Running Total In Power BI

Calculating a cumulative total, also known as a running total, in Power BI, is definitely common to most businesses due to its indispensability in performing calculations to show the total of a measure up to a certain date. But did you know that creating a reverse cumulative total is as essential as calculating the cumulative

Continue reading

Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend

It’s important for many businesses to make sure that you are analyzing over the correct sales periods or correct time periods in which you actually have results. If you implement formulas incorrectly in Power BI, especially with iterating functions like AVERAGEX or SUMX, and you iterate over days when you don’t have results, or days without

Continue reading

New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight that you can achieve using advanced analytics in Power BI. You’ll want to dive into this type of analysis because you need to evaluate

Continue reading

Find Top Customers Using RANKX In Power BI

Power BI is an amazing analytical engine! In this blog post, I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. I

Continue reading

FMCG Sales Analytics – Power BI showcase submission

Every consumer goods company needs this If you sell a product, good or service, you will no doubt want to be able to draw up some analysis on how you are going. What products are selling to which customers in what locations? Which warehouses or factories are producing them? How are we performing over time?

Continue reading