Get data from other table

[dominik_thoe]

Hello,

I have the following relation of two tables.

 I want to add the QTY from table "2018 monthly" to table "KEY". One seperate column for each "Cal.year/month" (01.2018 to 10.2018).

How can I do that?

Thanks

[Greg_Deckler · Accepted solution]

Perhaps try something like:

01.2018 = SUMX(FILTER(RELATEDTABLE('2018Monthly'),[Cal. Year/Month]="01.2018"),[QTY])

[dominik_thoe]

Perfect. Thank you.

[dominik_thoe]

One more question. Which function do I use if the value from table 2018 monthly is not decimal but text? Can be the first value.

Thanks