Forum Discussion
Creating a linktable with 2 dates from 2 different tables
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.
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
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
3 Replies
v-frfei-msftCommunity Support
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
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