Forum Discussion

wsMac78AZ's avatar
wsMac78AZ
Frequent Visitor
4 years ago
Solved

Filter Rows Identical Content Across Columns

Hope someone is able to help me.   I have a table below. I want to identify rows that have identical text across the 4 columns.     Breakfast Lunch Dinner Supper Monday Cereal Steak ...
Need Help
  • johncolley's avatar
    johncolley
    4 years ago

     

    Hi wsMac78AZ ,

     

    You can create a calculated column such as:

    Same Food = IF( 
    Meals[Breakfast] = Meals[Lunch] && Meals[Breakfast] = Meals[Dinner] && Meals[Breakfast] = Meals[Supper], 1, 0)
    You can insert the column as a basic filter as per picture to limit the table and put the column on a card.

     

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago

Simple enough,

PQ solution,

 

DAX solution,

 

For fun only, showcase of powerful Excel worksheet formula,