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 all, im looking to exclude a large number of text from a report (~500), some examples below. I've exceeded the amount on the basic filtering, so was looking for a query to assist or a different way.
Thanks in advance.
system-replmon
Spam Report
orion
mcafee.alerts
wsusadmin
Solved! Go to Solution.
Hi @cwstad,
From my original post, you should replace the "#PreviousStep" with the actual step name, not the first_name.
Take below image as an example, the underlined part is the previous step.
Best regards,
Yuliana Gu
Hi @cwstad,
Please refer to this M code:
= Table.SelectRows(#"PreviousStep", each not List.Contains({"system-replmon","Spam Report","orion","mcafee.alerts","wsusadmin"},[Column1]))
Best regards,
Yuliana Gu
Morning i have tried to run the code but i get the following error. I have also tried to change previousstep to first_name
.
Data im trying to filter
Hi @cwstad,
From my original post, you should replace the "#PreviousStep" with the actual step name, not the first_name.
Take below image as an example, the underlined part is the previous step.
Best regards,
Yuliana Gu
Hello i'm still not getting any joy with this.
Im opening the query editor pasting
= Table.SelectRows(#"PreviousStep", each not List.Contains({"system-replmon","Spam Report","orion","mcafee.alerts","wsusadmin"},[Column1]))
Changing the #perviousstep" to the step named vavigation in the applied steps window.
However i get the error
What am i getting wrong.
Thanks
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |