Custom Matrix Table

[TKBI]

Hi,

i am fairily new to Power BI so this is maybe a problem with a very obvious solution.

My problem is the following:

I have two Datasets loaded into my modell. One for actual sales data and one for budget sales data. The tables have no relationship and look something like this:

Actual Data:

Date	Quantity	Value
12-2022	1	100
01-2023	4	400
02-2023	3	250

Budget Data:

Date	Quantity	Value
12-2022	3	300
01-2023	2	120
02-2023	6	500

So far i had an excel document that visualized the data like this:

	Actual	Budget	difference	difference %
Quantity	8	11	-3	-27,2%
Value	750	920	-170	-18,5%
avg. Value	93,75	83,64	10,11	12%

I would really like to recreate the exact visual in Power BI but so far i came up with nothing. I assume this can be done via a custom matrix table and i found https://community.fabric.microsoft.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-Power... this guide explaining how to create one. Sadly there are a few differences from my problem to the example in the guide (differences like i dont use an existing dimension for the rows) and i am not experienced enough yet to compensate for that.

I would really appreciate any help i could get.

Thank you very much!

[TKBI]

So far I created two custom tables, one for the rows and another one for the columns using an idex in both tables.

These tables give me the columns and rows in the Matrix I need, but now the problem is to assign the right value to the right Row-Column pair.

I tried to put the Value-Actual measure into one field of the Matrix with following Dax Code:

---

---

Values for Matrix =

VAR calc = IF(

        SELECTEDVALUE(vt_columns[Index]) = 1,

             [Value_Act], 0

             )

Return

calc

This worked partly as i got the the measure to appear in the Row-Column pair with Index ID 1,1, but I am unsure how to adjust the code to get the other measures to appear in the field 2,3 for example.