Tag: DAX Formulas

Power BI And Excel: Difference In DAX Formulas

In this blog, I will quickly discuss the main difference between Power BI DAX and Excel formulas. I’ll show you some examples to help you see this better. I’m going to use the data that I used in the previous blog that tackled the differences between Measures and Calculated Columns. You may watch the full

Continue reading

What Is DAX? Understanding Its Meaning, Importance And Use

Once you understand transformations and data modeling, you can finally start working on visualizations on your reports. This would require a deeper understanding of DAX. You may watch the full video of this tutorial at the bottom of this blog. What Is DAX? What is DAX and why is it important? DAX stands for Data

Continue reading

Calculating A Rolling Average In Power BI Using DAX

In this tutorial, I’m going to show you how to calculate a dynamic Rolling Average in Power BI using the ALLSELECTED function. You may watch the full video of this tutorial at the bottom of this blog. Rolling Averages can give you valuable insights into a variety of data, especially in Sales. This dashboard shows

Continue reading

Revenue Forecast Technique for Project Data – Power BI Insights With DAX

In this tutorial, I’m going to show you a real-world insight that enables you to utilize project or opportunities data to create a Revenue Forecast in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This technique is extremely relevant to CRM systems. This can also be

Continue reading

Power BI Budgeting Technique: Allocating Monthly Budgeting Sensitivity Table

In this blog, I talk about a technique around Power BI budgeting, working out a way to allocate calculations across different time frames or months, for example. You may watch the full video of this tutorial at the bottom of this blog. In most cases, budgets are in a yearly basis. However, it’s so much

Continue reading