Forum Discussion

Rnaval's avatar
Rnaval
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Need Help creating new columns

Need Help
  • mariussve1's avatar
    mariussve1
    1 year ago

    Hi,

    For the OS Type you can use:

    OS Type = IF ( CONTAINSSTRING( '11936 Master'[OS], "Server"), "Server", "Workstation" )

    For the OS Name you can use:
    OS Name =
        SWITCH(
            TRUE(),
            CONTAINSSTRING( '11936 Master'[OS], "Windows"), "Windows",
            CONTAINSSTRING( '11936 Master'[OS], "Linux "), "Linux ",
            "Other"
        )

    Hope this helps, and please accept my answer as solution if this helps 🙂
mariussve1's avatar
mariussve1
Icon for Solution Sage rankSolution Sage
1 year ago

Hi,

For the OS Type you can use:

OS Type = IF ( CONTAINSSTRING( '11936 Master'[OS], "Server"), "Server", "Workstation" )

For the OS Name you can use:
OS Name =
    SWITCH(
        TRUE(),
        CONTAINSSTRING( '11936 Master'[OS], "Windows"), "Windows",
        CONTAINSSTRING( '11936 Master'[OS], "Linux "), "Linux ",
        "Other"
    )

Hope this helps, and please accept my answer as solution if this helps 🙂
  • Rnaval's avatar
    Rnaval
    Icon for Post Partisan rankPost Partisan
    1 year ago

    Thank You