Forum Discussion

Ericwhv's avatar
Ericwhv
Helper II
4 years ago
Solved

Question about data modeling

I could like to create a new column to determine that is our target data or not if that is our target data, the data showing in the field will be... "U" or "N" + ABCDEF + 01/02/03/04 which is 7 le...
Need Help
SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Ericwhv you mean like this? (This is a calculated column):

 

Check For Target = 
IF(
    LEFT('Table'[Input], 1) IN {"U", "N"}
        && RIGHT('Table'[Input], 2) IN {"01", "02", "03", "04"},
    TRUE,
    FALSE
)

 

 





      

Showcase Report – Contoso By SpartaBI

Ericwhv's avatar
Ericwhv
Helper II
4 years ago

Thank you Sparta!

that is the answer i needed, thank you!