Forum Discussion

dommyw277's avatar
dommyw277
Icon for Helper V rankHelper V
3 years ago
Solved

Nested IF statements not working

Hi,  Im trying to create a new column based on 3 queries? I basically want to say if it contains this then bring back that: So if it contains 123 its Test1, 456 its Test 2 else Test 3   NewColumn...
Need Help
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    Try this:

     

    NewColumnName =
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE], "123"),
"Test1",
IF(
CONTAINSSTRING('NewColumnName'[SERVICE_TYPE],"456"),
"Test2",
"Test3"
)
)

     

JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

What is the type of the column SERVICE_TYPE? Is it Text or Numeric? If it is text you are treating it as a numeric.

  • dommyw277's avatar
    dommyw277
    Icon for Helper V rankHelper V
    3 years ago

    Hi, yes its Text - it contains text and numbers?

    • JorgePinho's avatar
      JorgePinho
      Icon for Solution Sage rankSolution Sage
      3 years ago

      dommyw277 can you give an example of the values in that column?

      • dommyw277's avatar
        dommyw277
        Icon for Helper V rankHelper V
        3 years ago

        Thanks. Heres a brief example:

        cd6b6eec- Azure

        0b4c205 - AZURE 2