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
Tag: FILTER Function
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
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
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
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?