Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to create a custom column according to following input and expected output.
INPUT:
OUTPUT:
I want to check if id present in all_ids then get the value from all_unit according to the postion. e.g in the first row, we have id1 at first index then single_unit has 1. in the second row, we have id2 at second position then we get the value 4 in the single unit column and if the value does not exist then newly created column have null.
Please help me out.
thanks
zebra
Solved! Go to Solution.
Hi @zebra ,
a column with the following formula should do that job:
Text.Split([all_unit], ","){List.PositionOf(Text.Split([all_ids], ","), [id])}
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @zebra ,
a column with the following formula should do that job:
Text.Split([all_unit], ","){List.PositionOf(Text.Split([all_ids], ","), [id])}
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi, @ImkeF
Thanks for the quick reply, it solved the problem partially. I need to add the if condition to see index -1 otherwise it was giving error.
thanks
zeebee