Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
1 year ago
Solved

How to compare two tables for same column value

Hi All, I have a requirement to compare two tables and check if the column values in one table exists in another.   Two tables: 1. Master Table -- This table has row level security on user name ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

     Hi POSPOS 

    Thank you for providing Sample .Pbix file.
    use below DAX Expression and create a calculated column:

    Exist Status =

    IF(

       ISBLANK(RELATED('Custom'[Location])),

       "NA",

       "Exists"

    )

    Certain records in the detail table, specifically in the center column, do not have corresponding entries in the center column of the custom table, where a one-to-many relationship has been established. In cases where no matching records are found, the result should return as "NA". .



    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!! 

    Thank you



Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi POSPOS,

We have provided the required DAX expression and attached a screenshot for your reference. Kindly review it at your earliest convenience and let us know if it meets your needs.

we would appreciate it if you could Accept it as a solution and drop a 'Kudos' so other members can find it more easily.

Best regards,

Shamili.v