Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear, Community
i want to extract the value in columns to add to new columns : i just want to extract the value that not contain PP - or KP-
how can do that i think both can be doing by Base on it key or by the value in Column[Place] which it some value containt '' - "
Key | Places | New < columns> |
BBK | Phnom Penh | Phnom |
BBK | Kompot | Kompot |
BBK | Poipet | Poipet |
CNN | PP - Toul Kork | |
TDD | VN - Beung Keng Korng | |
DTD | KP - Terk Chou |
Hi @Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/UpdJBIaJqjoGUM3F
New Column =
VAR Items = SUBSTITUTE ( Data[Places], " ", "|" )
RETURN
IF (
Data[Key] = "BBK",
PATHITEM ( Items, 1 )
)
I don't want a substiute i just want to extract Full Value ( Phnom Penh is still Phnom Penh) the only value where the Key = BBK
@Anonymous
Then it would be
New Column =
IF (
Data[Key] = "BBK",
Data[Places]
)
it works but only for one key "BBK", so what if i want extract multiple value :
There a Parent key , code and name
As you see the picture under the Parent key we have BB1--> hold "
BB-BATTAMBANG |
BB-MOUNG RUESSEI |
BB-BAVEL |
"
And Code BB1 --> "BATTAMBANG RO"
It simply word i could say that BATTAMBANG RO is a Country and the BB- above is a City but it just store in one columns separate by Parent key and code
Hi @Anonymous
Kindly provide the expected output with esplanation based on this screenshot. Thank you
here is a expected output should look like
BB1 | BATTAMBANG RO | BB-BATTAMBANG |
BB1 | BATTAMBANG RO | BB-MOUNG RUESSEI |
BB1 | BATTAMBANG RO | BB-BAVEL |
@Anonymous
It seems I'm I am unable to undestand your requirement. My apologies. Maybe we can connect via Teams or zoom for better understanding. Please let me if you are aviable for a quick meeting. Thank you
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |