Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence

© Philip Seamark 2018

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

5. Joins

Philip Seamark¹ 

(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 ...