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...
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:
MFelix
Super User
Super UserHI 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: