Forum Discussion
Dax with condition
Hello, in a PowerBI report I have 2 tables as in the attached image. I am looking to establish the DAX formula which calculates the column "Is code" of Table 1 as follows: If the serial number begins with one of the Codes from Table 2, then Is code = "Yes", otherwise "No". What is the formula that allows me to do this? Thank you in advance for your help.
HI Anonymous ,
You need to add a column with the following syntax:
EstCode = IF( SUMX( 'Table (2)', FIND( UPPER('Table (2)'[Codes]), UPPER('Table'[Nº de Serie]) ,,0 ) ) > 0, "YES", "NO" )This is based on the following post:
1 Reply
HI Anonymous ,
You need to add a column with the following syntax:
EstCode = IF( SUMX( 'Table (2)', FIND( UPPER('Table (2)'[Codes]), UPPER('Table'[Nº de Serie]) ,,0 ) ) > 0, "YES", "NO" )This is based on the following post: