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
    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!