Forum Discussion

JKingFMG's avatar
JKingFMG
Regular Visitor
2 years ago

Update a Flag Based on Columns in Two Tables

Hello, I am trying to recreate an Access database process in BI Desktop involving 3 separate relationships between two tables (3 Access queries) and resulting in an updated exclusion flag in one of ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JKingFMG ,

 

Maybe you can try formula like below:

Scenario1 = 
IF (
    NOT ISBLANK ( 'tbl_30_Analysis'[Carrier] )
    && NOT ISBLANK ( 'tbl_30_Analysis'[Product] ),
    "Y",
    "N"
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.