Skip to main content
cancel
Showing results for 
Search instead 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

Reply
anonymous123141
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.

 

anonymous123141_0-1665592278932.png

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @anonymous123141 ,

 

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.

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @anonymous123141 ,

 

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.
rsbin
Super User
Super User

@anonymous123141 ,

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,

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.