We’re looking at a very cool feature that is found in Power Query Editor for this tutorial… namely the ability to create a new column that is based on another column. This is more impressive than it sounds, trust me. Post Subjects: Power Query We’re going to use a…
Today we’re exploring how to merge columns Power Query Editor. Sometimes you get stuck with data where two columns have data that SHOULD be in one column. We’re going to learn how to easily bring them together. Post Subjects: Power Query This post (and video below) uses a new blank…
Today we’re exploring how to split a column in Power Query Editor. Sometimes you get stuck with two data points in one column and you need to split them out into different columns so you can visualize each, or use one of them in a slicer or a filter.This post…
We’re exploring a really common function that comes with Power Query editor today, and that’s how to promote column headers in your data if Power BI can’t figure out what your headers are.This post (and video below) uses a new blank Power BI report and connects some simple data to…
We won’t get into too much detail about the nitty-gritty of each part of Power Query in this post. The Power Query tool is extremely powerful (and even has it’s own programming language), so we’ll have lots of posts about what it can do, but for now, we’ll start with…
