Creating a linktable with 2 dates from 2 different tables

[Anonymous]

Hello guys, I need to create a linktable with two differente date columns that are located in two different tables "issuance date" and "release date". How can i concatenate in one single table and separate between month, year and quarter.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

I made one sample for your reference. 

Create a calculated table using the formula as below.

Table = UNION(VALUES(Table1[issuance date]),VALUES(Table2[release date]))

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[Anonymous]

Yes, it does! Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

I made one sample for your reference. 

Create a calculated table using the formula as below.

Table = UNION(VALUES(Table1[issuance date]),VALUES(Table2[release date]))

For more details, please check the pbix as attached.

Regards,

Frank