Tag: Time Intelligence Calculations

Predict Future Profitability within Power BI DAX Functions

In this blog post, I will showcase some of the analytical work I enjoy doing the most… and that is working on future predictions using Power BI DAX functions. I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future

Continue reading

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.  This post will cover a high quality piece

Continue reading

Are Margins Expanding Or Contracting? Solve in Power BI

Here I’m diving into a relatively specific insight, but by walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of ‘measure branching‘, which I love implementing. It’s all about layering measures one on top of the

Continue reading