Forum Discussion

eilidh3's avatar
eilidh3
Frequent Visitor
5 years ago
Solved

DAX coding for new column

Hi all,   I'm after some help please šŸ™‚   Im looking to create a new column which will take two seperate columns, combine into one with one column overwritting some existing data.   I had start...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    eilidh3 

    You can use the following formula to the desired results in a column:

    New Column = 
IF(
    Table1[Market Sector ] = "Education",
        "Public",
    IF(
        Table1[Public / Private Sector] = "Public" , 
        "Public",
        IF(
            Table1[Public / Private Sector] = "Private",
            "Private"
        )
    )
)

     

Fowmy's avatar
Fowmy
Super User
5 years ago

eilidh3 

You can use the following formula to the desired results in a column:

New Column = 
IF(
    Table1[Market Sector ] = "Education",
        "Public",
    IF(
        Table1[Public / Private Sector] = "Public" , 
        "Public",
        IF(
            Table1[Public / Private Sector] = "Private",
            "Private"
        )
    )
)

 

eilidh3's avatar
eilidh3
Frequent Visitor
5 years ago

This worked perfectly!  Thank you!