We are going to go through quite an advanced tutorial here utilizing DAX formulas in Power BI What I want to show you is how we can work out; how many sales we have made from a specific customer….but, we only want to look at the last three sales or last N number of sales rather
I’m going to cover a very interesting topic around virtual tables, and how you can utilize them in Power BI within iterating functions. If you didn’t know it yet virtual tables are the essential ingredient to creating advanced logic inside of Power BI. A lot of the power of these virtual tables comes when you
Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example
In this video, I wanted to find an insight that was really unique, and hugely valuable for business. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling day for every single product that each store
I want to dive here into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing you what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just completed some
