For this blog post, I want to demonstrate the CROSSJOIN function. I’m going to show an example of how I used it, and then explain when and where you can use it as well. CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data
In this tutorial I run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI. I’m talking about forecasting product demand. Power BI is an amazing tool for data analysis when you can implement techniques like this one. Take a situation where you want to analyze future
Many times with the analytical work that you are completing, you may want to showcase anomalies. The reason for doing this type of analysis is that you will sometimes want to understand why you’re receiving some type of outlier or anomaly in your data set. Additionally, you want to be able to narrow your focus into
In this tutorial, I run through an advanced analytics technique in Power BI called Threshold Triggers. With this analytical concept in Power BI, you can set certain thresholds or certain trigger points via a supporting table in your data model. Once you’ve added this supporting table and it’s inputs, you can then run logic through
In this tutorial, we’re going to cover how to calculate quarter on quarter sales differences using time intelligence in Power BI. We’re not just going to do it at a granular level- we are going to try and analyze trends based on quarter on quarter sales. Sometimes when you are looking at something from a
