New to Power BI - compare "Exceptions" table to Fact Table - Identify any Matches

MikeL

Active Member
Joined
Mar 17, 2002
Messages
423
Hi,
I have a fact table - say with 1) description of fruit and 2) with quantity ordered.
I would like to take another table of exceptions (ie names of fruits that need to be flagged on fact table).

So if "Apples" is a record in the Exceptions table and is also a record in the Fact table, flag that record in the Fact Table. How to do this? I have read conditional formatting may not work in Power BI?
I want to keep the apple record in the primary Fact table, just want to identify it as being on another table.

Thanks in advance!
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,095,623
Messages
5,445,557
Members
405,339
Latest member
dayanand008

This Week's Hot Topics

Top