Lookup two conditions in another table and return TRUE or FALSE

[BartoszS]

Hi,

I have two tables structured like this:

Table 1

User ID	Username	Permissions
A1234	User1	Permission1
A1234	User1	Permission2
A2364	User2	Permission1

Table2

User ID	Username
A1234	User1
A2364	User2

I want to add column to Table2 that will return TRUE if the UserID and Permission1 exist for this User ID in Table1. False if they don't.

I have managed to use Excel function (IF and XLOOKUP) to get this information I need but because of the size of the data and formula complexity it takes days to run the functions (and they crash).

Is it possible to do it in Power BI DAX or in Power Query?

Thank you,

Bartosz

[amitchandak]

@BartoszS ,

a new column in table 2

=

var _cnt = countx(filter(Table1, Table2[USerid] = Table1[UserID]  && not(isblank(Table1[Permission]))  ), Table1[UserID] )

return

if(isblank(_cnt), false() , true() )