Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
5 years ago
Solved

Countif equivalent in Power BI

Hello.  I have a column in TableA that is a concatenate of two fields:  ProductID and CountryID.  In TableB, I have another column that is also a concatenate of ProductID and CountryID.  I am looking...
Need Help
  • Unicorn_Tech's avatar
    Unicorn_Tech
    5 years ago

    I ended up doing this, but I feel it's a bit convulted.  I couldn't get the above solutions to work.

    Match record = if(ISBLANK(lookupvalue(TableB[check], TableB[check], TableA[Check])),"No record", "Record")