Forum Discussion

dominik_thoe's avatar
dominik_thoe
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 c...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Perhaps try something like:

     

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

     

     

Greg_Deckler's avatar
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's avatar
dominik_thoe
Frequent Visitor
7 years ago

Perfect. Thank you.

  • dominik_thoe's avatar
    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