Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 presen...
Need Help
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    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.

     

     

     

     

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

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.