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 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
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |