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!
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!