Power BI Exchange

Hi there,

I have the following situation, and I couldn't find a solution to my problem.

I have two tables:

table A

and table B

* The values in the columns from Jan to Dec were input manually just for reference

Which formula or how do I return the sum of the values from column qty on table A to table B based on column state?

I tried this formula below, but I'm getting syntax errors.

jan = SUMX(
CALCULATETABLE(
'table A',
'table A'[month] = "jan",
'table A'[state] = LOOKUPVALUE( 'table A'[state], 'table A'[qty], table B[jan])
),
''table A'[qty]
)

Thanks!

Hi there,

I have the following situation, and I couldn't find a solution to my problem.

I have two tables:

table A

and table B

* The values in the columns from Jan to Dec were input manually just for reference

Which formula or how do I return the sum of the values from column qty on table A to table B based on column state?

I tried this formula below, but I'm getting syntax errors.

jan = SUMX(
CALCULATETABLE(
'table A',
'table A'[month] = "jan",
'table A'[state] = LOOKUPVALUE( 'table A'[state], 'table A'[qty], table B[jan])
),
''table A'[qty]
)

Thanks!