Forum Discussion

Frequent Visitor

7 years ago

Solved

Get data from other table

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

Perhaps try something like:

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

3 Replies

Greg_Deckler
Community Champion
7 years ago
Perhaps try something like:

01.2018 = SUMX(FILTER(RELATEDTABLE('2018Monthly'),[Cal. Year/Month]="01.2018"),[QTY])
- dominik_thoe
  Frequent Visitor
  7 years ago
  Perfect. Thank you.
  - dominik_thoe
    Frequent Visitor
    7 years ago
    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