Forum Discussion

CharnanK's avatar
CharnanK
Helper I
2 years ago
Solved

New Column

I need to create a column in a table, based on another column data.   New Column: Business Unit If LV Sector = North Coast Sector &/or Southern Sector - I want the new column to Show Regional opera...
Need Help
Show and Tell
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi CharnanK 

     

    Please create the following column
    BU =IF(
              OR(
                     'Table'[LV Sector] = "North Coast Sector" , 'Table'[LV Sector] = "Southern Sector"),
              "Regional Operations",
               "-"
             )

     

    If my post helps please give kudos and accept it as a solution!
    Thanks

amitchandak's avatar
amitchandak
Super User
2 years ago

CharnanK , Try a new column like

 

Business Unit =
IF(
'Table'[LV Sector] = "North Coast Sector" || 'Table'[LV Sector] = "Southern Sector",
"Regional Operations",
BLANK()
)

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.