Forum Discussion
DAX help
Hi,
I have two tables, one contain master table of ID (Table 1) and another table (Table 2) contains details of fact including ID.
Now I want to cross check whether ID from table 1 are present in table 2 or not. There is no join between two tables. I want to create a column that give whether it is exist in table 2 or not. My report is ID from table 1 and other columns from table 2. so that I will have all ID's from table 1 and will not miss any records if it is not present in table 2.
any workaround pls.
Hi Anonymous
You can solve this with LOOKUPVALUE(). Please find the example below
I have to table (Product and Customer). TRhey are not connected. Product ahs a ID column 1-6 and customer has an ID column 1-5.
Product Table
Customer Table
Now I created in the product table the following calculated column:
LookUp ID= var varLookUpValue = LOOKUPVALUE(Dim_Customer[PK_CustomerID],Dim_Customer[PK_CustomerID],[PK_ProductID]) RETURN IF(NOT ISBLANK(varLookUpValue),1,0)Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
1 Reply
Hi Anonymous
You can solve this with LOOKUPVALUE(). Please find the example below
I have to table (Product and Customer). TRhey are not connected. Product ahs a ID column 1-6 and customer has an ID column 1-5.
Product Table
Customer Table
Now I created in the product table the following calculated column:
LookUp ID= var varLookUpValue = LOOKUPVALUE(Dim_Customer[PK_CustomerID],Dim_Customer[PK_CustomerID],[PK_ProductID]) RETURN IF(NOT ISBLANK(varLookUpValue),1,0)Result
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.