Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am not a pro at Excel by any means but I'm trying to fix this one Excel file I have at work and I just don't have the knowledge to know what to put into it.
I'm trying to add more of that [RCCC]. I've tried adding commas after 300100 and it wouldn't do anything. I've tried adding "300100" , "######" and it only gives me an error.
What am I supposed to type so that I can add as many as I want? Please advise.
Thank you.
Solved! Go to Solution.
Hi @krispo ,
I think you can code as below to check list value.
= Table.SelectRows(#"Replaced Errors",each List.Contains( {"300100","300200"},[RCCC]))
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @krispo ,
I think you can code as below to check list value.
= Table.SelectRows(#"Replaced Errors",each List.Contains( {"300100","300200"},[RCCC]))
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@krispo Thanks for posting your query.
It seems like you are trying to replace values. If yes, just right click on the column and select Replace Values and type the values you want to replace and replace with and it should work.
If no, please share some more details and some sample data to work on. Thanks!
** 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, so that it comes in top of the search and help others. Thank you ! Good Luck 👍 |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |