Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 started with a IF statement but Im not convinced thats correct.
Public Sector should equal Public sector ,
Private Sector should equal Private sector
however I want to show all Education Market Sector as Public sector no matter what is in the Public / Private column.
Public / Private Sector | Market Sector | New Column |
Public | Health | Public |
Private | Commercial | Private |
Private | Education | Public |
Any help, as always, is greatly appreciated ! Thank you.
Solved! Go to Solution.
@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"
)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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"
)
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This worked perfectly! Thank you!
You can use an if condition ,
if([MarketSector] = "Education","Public",[Public/Private Sector])
Hope it helps
Please accept if this answers your query.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |