Forum Discussion
MMULT array in Power BI
Hi,
In column A1 I have a description, that description contain with comma, based on the description I am trying to check certain of the character.
If criteria is matched then return Yes, If not then return No, and If column A1 is blanks then rturn as a blanks.
Search criteria is India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark
Note: Search criteria is not allways same order. It's keep changing every line.
I am looking for DAX (New calculated column) option in order to get the desired result.
In Excel I am applying the following formula =IF(A2="","X",IF((SUM((MMULT({1,1,1},COUNTIF(A2,{"*,";"";"*,"}&{"Denmark","Belgium","India"}&{",*";",*";""}))>0)+0)=3)*(SUM((MMULT({1,1},COUNTIF(A2,"*Unit of Dimension for "&{"";"*/"}&{"Denmark","Belgium","India"}&{"/*";"*"}))>0)+0)=3),"YES","NO"))
Data:
| Description |
| Volume,India,Belgium,Denmark,Numerator for Conversion to Base Unit of Measure,Unit of Dimension for India/Belgium/Denmark,Volume unit |
| Volume,India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark,Numerator for Conversion to Base Unit of Measure,Volume unit |
| Denmark,India,Belgium,Numerator for Conversion to Base Unit of Measure,Unit of Dimension for India/Belgium/Denmark,Volume unit |
| Numerator for Conversion to Base Unit of Measure |
| Numerator for Conversion to Base Unit of Measure,Volume unit |
| Volume unit |
| Numerator for Conversion to Base Unit of Measure,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Belgium,Denmark |
| Numerator for Conversion to Base Unit of Measure,India,Belgium,Denmark,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume |
| Numerator for Conversion to Base Unit of Measure,Denmark,India,Volume,Unit of Dimension for India/Belgium/Denmark,Belgium,Volume unit |
| Numerator for Conversion to Base Unit of Measure,Volume unit,Volume,India,Denmark,Belgium,Unit of Dimension for India/Belgium/Denmark |
| ,Volume,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit |
| ,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Denmark,Belgium |
| ,Gross weight |
| ,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume |
| ,Unit of Dimension for India/Belgium/Denmark,Volume unit,India,Volume,Denmark,Belgium |
| ,Gross weight,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Denmark,Belgium |
| ,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume,Denmark,Belgium |
| Gross Weight |
| Belgium,Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume unit,Volume,Numerator for Conversion to Base Unit of Measure |
| Denmark,Belgium,India,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark |
| Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,India,Belgium,Denmark |
| Denmark,India,Unit of Dimension for India/Belgium/Denmark,Volume,Volume unit,Belgium |
| Belgium,Denmark,India,Unit of Dimension for India/Belgium/Belgium,Denmark,Volume,Volume unit |
| Belgium,Denmark,India,Volume,Volume unit,Unit of Dimension for India/Belgium/Denmark,Denmark |
| Volume unit,Volume,Belgium,Denmark,India,Unit of Dimension for India/Belgium/Belgium,Denmark |
| India |
| India,Belgium |
| India,Belgium,Denmark |
| Belgium |
| Belgium,India |
| Belgium,India,Denmark |
| Denmark |
| Denmark,India |
| Denmark,India,Belgium |
