I am having 2 tables named as table 1 and table 2 but not related to each other.
What i am looking for DAX formula for "Table 1" column B as shown below, if any of the part number from column A in excel (which is table1 in power BI), match with column I in excel (which is table 2 in power bi) and if column J is True for any part number, then expected result should be true please.
There are some instance where column J will have both true and false for same part numbers and in that case True will be over ridden please.
I am using below DAX code what should i do please to get information from same table and from same column please. That is i have attached an example "Modified status" which will look for material in the same column (it will be more than 2 in some cases) and if the match found then if "Status" is "Yes" for any of the matched part then "Modified status" will be yes for that part number please.