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. Let’s get straight to it.
Tag: Power BI vs Excel
In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. This is most useful when we’re getting data out of Microsoft Excel because most of its data will contain subtotals. We’ll be using some oil and gas statistics found online. Subtotals In
For years I’ve heard and listened to all the marketing buzz around how businesses could develop data driven cultures. With so many data visualisation tools now pushing the same message, how can you evaluate what has worked and will work in your own business environment? Many of the tools have gone on to have quite