If you’re stuck with a syntax error and looking for the short answer, here it is. Let’s move on to the long answer. Can I use the IF statement in the Power query? Yes. you can use an if statement in Power Query but the syntax is slightly different from what it is in DAX.
Month: November 2023
Introduction Let’s split this generic linear sale data chart into multiple line charts by year (months or quarters ). Sales data for the first example, we have a generic sales dataset. It has Order date and Profit etc columns plus 4 years’ worth of data. We can add these 2 columns to a line chart
Getting a running average in Excel is pretty easy. You just need to add the last 12 cells in the AVERAGE ( ) formula and autofill the table would do the trick. In Power BI, however, it’s a little bit tricky. In this post let’s find out how. The DataSet Table of sales values of