Learn how to pull data from another table matching one or more columns. I’ll show you how to easily do this using the LOOKUPVALUE command, the CALCULATE command and a trick to join Power BI tables on more than one column.
0:00 Intro
0:39 HR example - Pull a value from another table matching one column
2:40 HR example – Get a value by setting up a table relationship
3:15 Inventory example - Pull a value from another table matching one column
6:00 Inventory example – Pull a value from another table matching 2 or more columns
8:43 HR example – Pull a value from another table matching 2 or more columns
11:19 Trick to make a Power BI relationship connect on two or more columns
======================================
Resources:
Web site: numericalinsights.com/
Digital downloads/templates: numericalinsights.com/store
LinkedIn: linkedin.com/in/numericalinsights/
Newsletter Sign-up: numericalinsights.com/sign-up
- How to pull data from another table matching one or more columns (Power BI) ( Download)
- 4 Ways of Getting Column from one table to another in Power BI ( Download)
- How to Match and Get the Value from another table | Power BI scenarios videos ( Download)
- Bring a column value from one table to another table in Power BI | LOOKUPVALUE function in Power BI ( Download)
- Creating new Power BI Table by filtering values from another table column ( Download)
- Excel PowerQuery: Match multiple columns between two tables ( Download)
- 15.4 Merge Data Having Multiple Criteria or Multiple Columns in Power BI (Power Query) ( Download)
- LOOKUP VALUE WITH MULTIPLE CRITERIA IN POWER BI | 2 WAY LOOKUP FORMULA IN POWER QUERY AND POWER BI ( Download)
- Creating new Power BI Table by Combining Distinct Values from Multiple Tables ( Download)
- How to use LOOKUPVALUE to match data between two tables // Beginners Guide to Power BI in 2021 ( Download)
- How to Join Two Tables on Multiple columns in Power BI | Join Two Tables on COMPOSITE KEY |BI Tricks ( Download)
- DAX Fridays! #41: LOOKUPVALUE with multiple columns ( Download)
- Power BI - How to count rows of one table that are not appearing in another table ( Download)
- 3 Ways to SIMPLY Compare Matching Values Across Two Files Using Power Query | #powerbi ( Download)
- Multiply 2 columns from 2 different tables in PowerBI using DAX | MiTutorials ( Download)
