Alternatives to Vlookup to Merge data in Power BI using Relationships, LookupValue, Sumx and Values

Опубликовано: 10 Июль 2023
на канале: Lighthouse Analytix

1,893

How to look up values in Power BI? In this tutorial, you will learn how to merge and combine data from various tables whilst showing the CORRECT TOTAL.

If you come from an Excel background… then you must be familiar with Vlookup and Xlookup concept in Excel.
And if you are new to Power BI.. and you want to merge data from various tables….You may be thinking… how do we do this in Power BI? What type of DAX function do we need to use? And also... how to show the correct total? What's the alternatives to Vlookup and Xlookup in Power BI?

How often do you get excited that you may have found a solution, but your total is Wrong? Isn't that an annoying feeling?

You have come to the right place.

In this video, I'm going to show you HOW we can merge and combine data from various tables in Power BI as well as HOW to ensure that the Correct Totals are being displayed after we merge the information.

Instead of using Vlookup or Xlookup, there are alternatives way of doing LookUp in Power BI, by using...
RELATIONSHIP
LOOKUPVALUE DAX to create a new measure
SUMX and VALUES combo to create the CORRECT TOTAL.

Hope you enjoy this video & see you next time !!!

Cheers,
Isabella Susilowati ‪@LighthouseAnalytix‬
#powerbi, #powerbiforbeginners, #powerbitutorial

Timelines:
00:00 Intro
01:03 Let's get started
02:13 Sneak peak to our Data Model
02:46 Example 1
04:37 Example 2
05:28 How to show the Correct Total
06:12 LOOKUPVALUE
07:50 SUMX
09:34 What is VALUES
10:55 Epilogue

Music by Bensound.com/royalty-free-music
License code: XSY6SHDI5ZVJVVHU

LA112