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>|
|CNN||PP - Toul Kork|
|TDD||VN - Beung Keng Korng|
|DTD||KP - Terk Chou|
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 ) )
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 "
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
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.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.