
Using Group by to Concatenate Text in Power Query
In this post you learn how to group your data and concatenate text values. … Read more
In this post you learn how to group your data and concatenate text values. … Read more
The IF function in Power Query is one of the most popular functions. It … Read more
Trying to sum columns with null values in Power Query but getting unexpected results? … Read more
Introduction As Power Query beginner, it is comfortable to use the user-interface to change … Read more
A XLSB File error can come to you by surprise. Recently one of my … Read more
In this post you learn how to define a Data Type at the same … Read more
Scraping content from the web is getting easier and easier. Sometimes for the data … Read more
This post shows how to perform a crossjoin between tables in Power Query. There … Read more
Recently I worked on a challenge from Ken Puls, where I needed to figure … Read more
Data comes in countless ways and forms. Sometimes structured, with an SQL database, a … Read more
Receive the latest article in your mailbox