Forum Discussion
FILTER into new table, compare columns
Hello
I would like to use FILTER to create a new table filtering the rows by a comparison. According to documentation, FILTER is a "function that is embedded in other functions that require a table as an argument". What function should I use to get this table as a result?
Also, I'm having trouble making the boolean expression of comparison. I have two columns called Count and Max. I want to keep only the rows where the value of Count is the same as the value of Max. I only know how to compare a value in a column to a given value.
2 Replies
- parry2k
Super User
lucilach your question is not very clear. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - v-joesh-msft
Solution Sage
Hi lucilach ,
I'm a little confused by your description, kindly share your sample data and expected result if you don't have any Confidential Information.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.