Forum Discussion
DAX for Input Output Analysis
Dear all I am embarking on a project to construct an input-output matrix encompassing several regions and economic sectors. To illustrate, let’s consider 3 regions and 4 sectors. This will result ...
Adescrit
Impactful Individual
Impactful IndividualHi angsoka
You should be able to achieve the 12x 12 matrix with a dataset with four columns:
Region Sector Input Output
You can then create a 5th column on the table using DAX with the logic:
Not Sector 4 Calc =
IF( Table[Sector] = "sec 4", Table[Sector], "Other than 4 )
You can use similar logic for the "Non C" calculation on regions. Then add both of these new columns to a matrix visual in Power BI, with calculations to sum the input and output.