Verknüpfung von zwei Tabellen mit Plan- und Ist-Umsatzwerten

[JohannesB]

Hallo,

ich habe 2 Tabellen mit folgenden Spalten:

Tabelle 1: Datum I Filiale I Plan-Umsatzwert

Tabelle 2: Datum I Filiale I Umsatzwert

Wie bekomme ich die beiden miteinander verknüpft? Eine 1:1 Verknüpfung des Datums oder der Filiale funktioniert nicht.

Somit funktioniert der Abgleich auch nicht. 

[JohannesB]

Sorry, but how can i do that? I got the date and the branche into a single column, but how am i doing it with the key? 

[AmiraBedh]

Can you show me what you tried so far?

[JohannesB]

Hello,

I have combined the columns "Branch" and "Planned value" in one column (see image). I have also done this with the other table "Store" and "Actual value".

What else do I have to do so that I can link the "Store" or "Date" columns of both tables?

[AmiraBedh]

Hallo !

Please note that we use English in this platform to communicate.

You need to create a new column that combines the Date and Branch columns into a single composite key.

For Table 1 (Planned sales):

CompositeKey = CONCATENATE(Table1[Date], Table1[Branch])

For Table 2 (Actual Sales):

CompositeKey = CONCATENATE(Table2[Date], Table2[Branch])

Once you have a composite key in both tables, you can create a relationship between them based on this new key.