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 Guys,
I want to extract some text from a column based on the position of a delimter defined in another column.
Example of data
So i want all three Names column to be populated from values extracted from column FD.
Level columns define the position of delimter i.e. "_" after which the name exist for that particular column.
I would also like to handle the blank values the same way was mentioned in the table.
I am looking for a function in DAX to populate these column but incase you know how it's done in Power query that's also fine.
Any help in this regard will be highly appreciated.
Thanks,
Uzair
Solved! Go to Solution.
Check the attached file, the result it's different but I believe it can help you.
Hi,
You may download my PBI file from here.
Hope this helps.
@Ashish_Mathur Thanks for the help.
I am going with the @camargos88 solution. But that's neat trick you did with keyword.
Check the attached file, the result it's different but I believe it can help you.
@camargos88 Thanks.
It's funny that I just found the similar solution. I used the below code which apparently do the trick.
if [FruitLevel] <> null then ( Text.Split([FD], "_"){[FruitLevel]}) else null
The main problem is those levels columns are created using DAX Lookup, so I don't think I can use those columns with Power Query function.
Do you have any idea how can I achieve this ?
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 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |