Remove records based on second query

[DeanMcK]

Hi All,

I'm an absolute newby to the world of Power BI.

I have an excel dataset I have imported into Power BI and with this dataset I need to remove a group of UserUuid which are in a second query I imported.

How is the best way for me to remove the UserUid's from the original dataset?

These are the two queries I have joined by UserUuid.

Any help is appreciated.

Regards

[danextian · Accepted solution]

Hi @DeanMcK ,

Using DAX in the designer, you can create a calculated column to indicate exclusion of data from your report.  Assuming Original Data Combined table is on the many side of the relationship, create a calculated column in this table: 

ToExclude =
IF ( ISBLANK ( RELATED ( Remove_UserID[UserIdUuid] ) ), "Y", "N" )

Of course, this only indicates whether a row is to be excluded but does not really remove those rows from the dataset.

In the query editor, you may use the merge function to join the two tables. Select Inner from Join Kind to keep matching rows only. 

[DeanMcK]

Thanks @danextian ,

That allows me to filter on that column.

Thanks heaps

DeanMcK