© Philip Seamark 2018
Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_5

5. Joins

Philip Seamark1 
(1)
UPPER HUTT, New Zealand
 

Joins in DAX

This chapter looks at options for using and combining data from different tables in calculations without necessarily using the relationship mechanism.

It’s common for calculations to use data from multiple tables. Most scenarios can be covered automatically through the standard table relationship defined in the data model, but not in every case. If you need more flexibility, several DAX functions are available that support joining tables. Some of these provide an experience that should be familiar to you if you are used to writing T-SQL queries. I highlight the similarities and ...

Get Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.