How do I check for two columns in a single table to see if they match? I need to create a column labeled "Check" to find ID where type A maches type B. TIA
Go to Solution.
@lpd82 , Try a new column like
new column = var _id = [ID] var _Ty = [Type] var _1 = countx(filter(Table, [ID] = _id && [Type] <> _ty),[ID) return if(isblank(_1), False(), True())
Proud to be a Super User!
View solution in original post
Perfect! Thank you.
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!