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
Click here to read more about the November 2022 updates!
This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.
Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.