If you want to add a column from another table in Power BI, first add a column when there is a relationship between tables, then use Power Query.

When I’m working with XML files, or web pages, or any data with columns containing nested tables in Power Query, I often end up having to expand every expandable column in the table and then expanding ...

Learn how to handle column name changes in Power Query and prevent workflow failures with expert tips and dynamic solutions.

After my post earlier this week on creating current day/week/month/year reports in Power BI a few people asked me for a more detailed explanation of the way I was creating tables without using a data ...

Although using a conditional column in this way is quite straightforward, once you start needing to enter multiple else if lines, it might well be preferable to construct a separate table and create ...

Note: the Power Query tools started off as an optional add-in for Excel version 2010 and 2013 before they became an integral part of Excel 2016 as the Get & Transform group of the Data Ribbon tab. The ...

Discover expert Power Query tips to reduce steps, streamline workflows, and optimize performance for cleaner, faster data transformations.

A super easy way to generate new records from multi-value columns using Excel Power Query Your email has been sent Have a complex Excel problem? Power Query to the rescue! Analyzing data often ...