RELATED (DAX – Power Pivot, Power BI)
Let´s say we have table of sales of items, and table of prices of these items. What we need is to add prices from the pricelist to the table of sales.
This is the table of sales:
This is the pricelist:
The Related function only has one argument – the target column. In contrary to VLOOKUP, which needs for arguments – because it does not have the information “included” in the relationship.
To get the data backwards (from sales to pricelist), use the RELATEDTABLE table.