Solved: Re: Get data from other table

dominik_thoe · ‎11-20-2018

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 · ‎11-20-2018

Perhaps try something like:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎11-20-2018

Perhaps try something like:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

dominik_thoe · ‎11-21-2018

Perfect. Thank you.

dominik_thoe · ‎11-21-2018

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

Get data from other table