ETLPower BI

How to Find a Value by searching Multiple Columns in Power BI

By 26/09/2019 October 8th, 2023 No Comments

Problem: We were combining data from 2 source systems and transforming directly within Power BI and as a result, need to filter Contract Manager which can come from either system

Approach: You can create derived column and use CONCATENATE DAX formula to get the value, DAX example as below and then you can use Text Filter – so it can filter in either column

DerivedFiledName = CONCATENATE( ‘DataSource 1′[DS1FieldName]   ,’DataSource2′[ DS2FieldName])

Leave a Reply