Excel Unplugged

Monthly Archives: February 2022

Why You Should Know Power Query – Part 3: Merge

Power Query is a great tool for data transformation. I often use as an upgrade to Excel. We already covered two great functionalities in first two parts: fill and ...

Why You Should Know Power Query – Part 2: Split

Power Query can be more than an ETL tool – I often use it as an upgrade to Excel. It has some neat functionalities that make transforming data so much more ...

Why You Should Know Power Query – Part 1: Fill

Power Query is meant to be an ETL tool, but I often find myself using it in addition to Excel. Power Query has some neat functionalities that make transforming data ...

Data Types – Part 2 – Create Your Own Data Types in Power BI
February 1, 2022

Let’s see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it’s done in Power Query. How-to We start by ...