topic Joinning two tables in dax code in Developer

Joinning two tables in dax code

Anonymous — Thu, 04 Jun 2020 06:26:15 GMT

I'm new in dax and here is my question; I have two tables(sql views) in tabular:

Fact table

Key_col1	Prodnr	col1
101	P0005	517
102	P0037	620
103	P0074	240

and in table2

Dimension table

Key_col2	col2	col3
102	620	PE412
101	517	AE309
103	240	EF903

In tabular I've created a relation between two tables with their key columns and want to write a dax code that when I select for example P0074 from a slicer , it shows EF903 as a part of information in report.

Re: Joinning two tables in dax code

lbendlin — Fri, 05 Jun 2020 13:42:23 GMT

If you want to do this in DAX you need to use either LOOKUPVALUE or TREATAS.

Why not do this in the model view though?

Re: Joinning two tables in dax code

Anonymous — Thu, 11 Jun 2020 13:19:42 GMT

I resolved it by creating a new view.