cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Multi Column Comparison

Hello,

I have a table with multip rows of data for "Item #'s" and I need to compare Item # with "All shipped." I want a new column, that returns a "yes" for all item numbers where there is one instance of all shipped being yes.

1 ACCEPTED SOLUTION
Community Support

Check this formula:

``````Column =
var isyes = CALCULATE(MAX('Table'[All shipped]),FILTER('Table','Table'[Item#]=EARLIER('Table'[Item#])))
return
IF(isyes = "yes","yes","no")``````

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
2 REPLIES 2
Community Support

Check this formula:

``````Column =
var isyes = CALCULATE(MAX('Table'[All shipped]),FILTER('Table','Table'[Item#]=EARLIER('Table'[Item#])))
return
IF(isyes = "yes","yes","no")``````

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

Please try this as your [New Column]:

``````New Column =
VAR _Item = [Item #]
VAR _Yes = CALCULATE( COUNTA( [All shipped] ),
FILTER( YourTable, YourTable[All shipped] = "YES" &&
[Item #] = _Item ))
RETURN
IF( _Yes >= 1, "Yes", Blank() )``````

Hope this works for you.

Regards,

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors