Combining Latest Date From Two Table

[tomperro]

I have a matrix table showing latest dates of various tests employess have taken. The tests are in 2 seperate tables so I am showing the latest date of each test but I am getting 2 columns because I need max date for each test.

Example:
Test Table 1

EmployeeID	Test Number	Date
1111	11	1/1/2020
1111	11	2/2/2020
1111	33	3/3/2020

Test Table 2

EmployeeID	Test Number	Date
1111	aa	11/11/2020
2222	bb	2/22/2020
3333	cc	3/30/2020

What I am showing in BI

Matrix Table

EmployeeID	Test Number	Date (Test Table 1)	Date (Test Table 2)
1111	11	2/2/2020
1111	33	3/3/2020
1111	aa		11/11/2020

What I want to show

EmployeeID	Test Number	Date
1111	11	2/2/2020
1111	33	3/3/2020
1111	aa	11/11/2020

[Ashish_Mathur · Accepted solution]

Hi,

Ensure both tables have the same headings and append them.  To your visual, drag ID and Test and write this measure

Last date of test = max(Data[Date])

Format this measure as Date.

Hope this helps. 

[freginier]

In dax you can create a calculated column to concatenate column from tab1 and tab2 using CONCATENATE and RELATED functions. 

[tomperro]

How do I do this?