Extract Data Based on the Previous Row
This is a cool example of how to Extract Data Based on the Previous Row, which came up as a viewer's question inside our Power Query Academy. Let's look at how we solved it… What Kind of Data Needs This
This is a cool example of how to Extract Data Based on the Previous Row, which came up as a viewer's question inside our Power Query Academy. Let's look at how we solved it… What Kind of Data Needs This
I was playing around with a scenario this morning where I was adding try results together in order to count how many columns were filled with information. What I needed to do kind of surprised me a little bit. The
This post is a guest article from Marcus Croucher, a finance professional based in Auckland, New Zealand. Marcus instantly fell in love with Power Query after seeing how it can easily transform data in ways Excel finds difficult, and how
DIY BI eBook Series: Tips, Tricks and Techniques for Building Your Own BI Solutions This free eBook series is available to our Excelguru email newsletter subscribers. Each book contains five of our favourite tips, tricks, and techniques, with one book
Power BI COURSE DESCRIPTION Make your data come to life with beautiful, interactive reports in Power BI. Ken Puls has worked with a company called GoSkills to help design and build an introductory course which is offered in an online
Ages ago I posted an article on unpivoting subcategories using Power Query. The technique is still valid and, in fact, it’s one that I still teach using the same data set. I’ve been able to use it on data with
One of the common questions I get in live courses, blog comments and forum posts is a variant of, “How do I format my data in Power Query or Power BI?” The short answer is that you don’t, but the
ON-DEMAND: Power Query Academy Course Description What is Power Query? Power Query is the most important data analysis tool since PivotTables. It allows you to clean, reshape, and combine your data with ease, no matter where it comes from. Introducing
Legacy Installers for Power Query and Power BI Desktop Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but
A client contacted me today asking how to merge files with different column headers in Power Query. The issue she's facing is that some of the files in her folder have a column called "customer", where others have a column
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.