Tag: Advanced DAX

Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days

Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI. You may watch the full video of this

Continue reading

Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX

In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on historical information and complete it in an automatic way. You may watch the full video of this tutorial at the bottom of this blog. When you create budgets and forecasts, sometimes

Continue reading

Using Multi-Layered Scenario Analysis in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. You may watch the full video of this tutorial at the bottom of this blog. In Power BI you can complete this really

Continue reading

Last Purchase Date in Power BI: When Did Your Customers Make Their Last Purchase?

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success. One way to do this is by knowing your customers’ last purchase date in Power BI. You may watch the full video of this tutorial

Continue reading

Cumulative Totals In Power BI Without Any Dates – Advanced DAX

Cumulative Totals In Power BI Without Any Dates - Advanced DAX

Here, I’m going to show you how to calculate cumulative totals or running totals with no dates nor index columns. You may watch the full video of this tutorial at the bottom of this blog. Somebody actually asked about this on the Enterprise DNA forum. The member who posted it encountered some quite complex algorithm

Continue reading