Forum Discussion
Helper IRemove repeated values in different sheets
Hi ! I have 3 different sheets in Power BI that are created based on "3X9" , "5X9" and "20X9".
I need to have a condition here. If the values is present in "3X9" then that values should be deleted from "5X9" and "20X9" sheets. And if the value is present in "5X9" then it should be deleted from "20X9" sheet.
Thank you !!
2 Replies
- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. I cannot help you without meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - ChenwuZhu_Gmail
Resolver I
Hi ganeshnr073 ,
You can create a new custom column in power query editor.
Use the following code to do that.
= Table.Contains(#"Sheet1 3*9",[ Number = [Number] ])Result:
Pbix file in the end you can refer.
Best regards
