Tag: Time Intelligence Calculations

Power BI Trend Analysis: Are Margins Expanding Or Contracting?

In this blog post, I will be diving into a relatively specific insight by conducting a Power BI trend analysis. 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

Continue reading

How To Do Trend Analysis In Power BI Using DAX

Power BI Tracking and Visualizing Trends

Showing trends and how they change over time can add a lot of value to your consumers and decision makers. In this post, I will show how to use conditional formatting inside Power BI tables to showcase this insight really well. Obviously to show a trend analysis in Power BI, we actually need to calculate

Continue reading

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