Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.