Protected: Subscriber’s Resource: Robust Column Merge
Password Protected
To view this protected post, enter the password below:
Remove Duplicates, Lookup Tables and Pitfall #10 in #PowerBI and #PowerQuery
In today’s post, we will learn about the tenth pitfall in Power BI and Power Query in Excel (Read all pitfalls here). For this special occasion, we’ll get some help from R2-D2 and his friends, and demonstrate the pitfall with Star Wars data. Are you a...
Expand Table Column – Pitfall #9
Follow @gilra It’s time to expand table columns today, and get you acquainted with the ninth pitfall, which can be quite risky, as you’ll soon find out. For those of you who didn’t read my previous articles of the Pitfalls Series, you are welcome to...
Removing/Selecting Columns – Pitfall #5 in #PowerBI and #PowerQuery
In today’s episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when you import data to Power BI, or to Excel (using Power Query / Get & Transform) – You remove...
Column Reordering Disorder – Pitfall #4 in #PowerBI #PowerQuery
Follow @gilra Order is a crucial force in life, especially if you are a data analyst. But as we will see today, the misuse of order might cause an unexpected chaos. In today’s post, we will discuss the chaotic nature of column ordering in the Query Editor of...
