Forum Discussion

pcav's avatar
pcav
Helper I
7 years ago
Solved

Create column based on MAX date in associated table

I have a  data structure where a row in the Table1 has multiple associated rows in Table2.  Each row in Table2 has a date and time column.   What I want to do is create a date and time column in...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    pcav

    It will work anyway. Although in that case the FILTER( ) is redundant.  

AlB's avatar
AlB
Community Champion
7 years ago

Hi pcav

 

I understand you want to show in Table1 the latest date that appears in Table2 for that Id? If so you can create your new calculated column in Table1 as follows:

 

CalculatedDate =
CALCULATE ( MAX ( Table2[Date] ), FILTER ( Table2, Table2[Id] = Table1[Id] ) )

 

This assumes no relationships between Table1 and Table2

 

pcav's avatar
pcav
Helper I
7 years ago

Thanks but that will not work as there is a relationship between table1 and table2 which is "Id"