Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There....I want to remove items from a column by adding a condition in the query....please help me how do I proceed
Solved! Go to Solution.
You can add a filter steps using any of your current values and then modify using the pattern below.
= Table.SelectRows(#"Previous Step", each List.Contains({"CurrentItem", "FutureItem"}, [ColumnToFilter]) = false)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Analyst001
Your needs are not very clear, maybe you can provide some data or the results you want ?
I created a sample , you can refer to it
Original data:
I want to remove the content of 2 from the content of 1 .
And add a custom column .
Result=Text.Combine(List.RemoveItems(Text.Split([Column1],","),Text.Split([Column2],",")),",")
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can add a filter steps using any of your current values and then modify using the pattern below.
= Table.SelectRows(#"Previous Step", each List.Contains({"CurrentItem", "FutureItem"}, [ColumnToFilter]) = false)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can just put filter in your columns e select the itens that you want or need. After the selection, load the table.
I cannot use filters as one item is from the list and one is coming in the future