Forum Discussion

cyed's avatar
cyed
New Member
6 years ago
Solved

Create table with intersection column

Hi!

 

I have a table with two columns: one of users ("User") and one of applications ("Application") they use.
I have a second table with one column: the applications that can be used ("White List").
I need to create a third table with one column: consisting of applications that cannot be used ("Blacklist"), to use it as a filter in the first table.

 

Can anybody help me?

 

Thanks in advance!

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi cyed ,

     

    You could refer to the following DAX to create a new table:

    New Table = 
VAR a = DISTINCT('Table'[Application])
var b = DISTINCT('Table (2)'[White List])
return
EXCEPT(a,b)

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi cyed ,

     

    You could refer to the following DAX to create a new table:

    New Table = 
VAR a = DISTINCT('Table'[Application])
var b = DISTINCT('Table (2)'[White List])
return
EXCEPT(a,b)