Using matrix multiplication

Multiplying matrices or tables is a fairly common mathematical operation, particularly in the field of matrix algebra. There are certain statistical calculations, such as Krippendorff's Alpha, that require matrix multiplication. Excel has a handy function called MMULT that performs matrix multiplication in a single function. Unfortunately, DAX has no equivalent MMULT function.

This recipe demonstrates how to perform matrix multiplication using DAX.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R07_Table3x4 that contains the following data:

Column1	Column2	Column3	Column4	Index
-4	1	4 ...