Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
When you import data to Power Query, it's not unusual to end up with a table containing blank rows and columns, like this There are a few ways to get rid of these 'blank' rows and columns, some better than others. Watch the Video Download Example Excel Workbook Enter your email address below to download …
This is my source data and I want to remove the percentages Specifically I want to remove all occurrences of (00%) so my data ends up like this There's no native function in Power Query to do this so I'll have to write my own code. Watch the Video Download Sample Excel Workbook Enter …
In a previous post I looked at creating running totals in Power Query, here I'll be creating grouped running totals. I'll start with a table of data showing values for cities within different countries. Download the Workbook With Sample Query The queries in this Excel file can be copied/pasted into the Power BI Desktop Advanced …
A running total (or cumulative sum) is when you add the previous value to the next, basically you're summing values every step of the way. Creating a running total in Excel is easy. Mynda has written about a couple of ways you can do it Running Totals in Excel Running Totals in Excel Tables But …
If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically takes some input and gives you an output. The input, for example, could be a range, a number or a piece of text. The output type will vary, the SUM function will output a number, …
