Advanced Power Query Merge in Power BI: The "Range" Merge with No Exact Match
This video covers the "Range" Merge in Power Query in Power BI. The "Range" Merge is used when there is no exact match between columns and a value needs to be compared to a range. The video explains the problem and provides a solution for the "Range" Merge. The Self-Merge, another type of merge, will be covered in a future video. The video also introduces Avi Singh, a Power BI Pro. The topics covered include an introduction to the three Power Query Merges every beginner should know, the "Range" Merge problem, the solution to the problem, and building the data model after loading Power Query.
Video 7m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time