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
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.
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.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
