Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Exclude rows if two values in same table are the same

I'm trying to figure out how to create a filter which will exclude rows in my report if values in two separate columns are equal.

For example:

KEY VALA VALB

123 5 6

456 5 5

I want the filter to exclude key 456 from report.

Any help would be greatly appreciated.

v-lili6-msft
7 years ago
hi, Anonymous
there is a simple way that create a calculate column to judge if two values of the current row are the same
judge = IF(Table1[VALA]=Table1[VALB],"yes","no")
then drag the field into report level filter to filter value is "no"

Best Regards,
Lin

3 Replies

v-lili6-msft
Community Support
7 years ago
hi, Anonymous
there is a simple way that create a calculate column to judge if two values of the current row are the same
judge = IF(Table1[VALA]=Table1[VALB],"yes","no")
then drag the field into report level filter to filter value is "no"

Best Regards,
Lin
- Anonymous
  Not applicable
  7 years ago
  Thanks! That worked great! I used TRUE and FALSE instead of "yes" and "no"
  
  Eric
Anonymous
Not applicable
7 years ago
Create another column:
FILTER = IF(VALA = VALB,"Yes","No")
Then you can filter according to the value of the new column