Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Thimma
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.
Hi @Thimma
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |