MAX of Multiple Columns? Why is this not working?

[ericOnline]

I have three tables. I need the MAX timestamp from a column in each table. 

Why does this not work? 

ALL_LastRecord = 
    VAR var1LatestRecord = MAX(table1[timeStamp])
    VAR var2LatestRecord = MAX(table2[timeStamp])
    VAR var3LatestRecord = MAX(table3[timeStamp])
    RETURN
    MAX(var1LatestRecord, var2LatestRecord, var3LatestRecord)

How would I accomplish this in DAX?

(Without merging any tables, adding columns, etc.. I do not want to manipulate the tables to do this. Should be straightforward in DAX.)

Thank you 

[Greg_Deckler · Accepted solution]

You need MC Aggregations:  https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

"I like big aggregations and I cannot lie

You other PBI'ers can't deny"

[amitchandak · Accepted solution]

@ericOnline 

Try

ALL_LastRecord = 
    VAR var1LatestRecord = MAX(table1[timeStamp])
    VAR var2LatestRecord = MAX(table2[timeStamp])
    VAR var3LatestRecord = MAX(table3[timeStamp])
    RETURN
    MAX(var1LatestRecord, max(var2LatestRecord, var3LatestRecord))

[Greg_Deckler]

Also, with your code, you could have done:

ALL_LastRecord =
VAR var1LatestRecord = MAX(table1[timeStamp])
VAR var2LatestRecord = MAX(table2[timeStamp])
VAR var3LatestRecord = MAX(table3[timeStamp])
RETURN
MAXX( {var1LatestRecord, var2LatestRecord, var3LatestRecord}, [Value] )

[Greg_Deckler · Accepted solution]

You need MC Aggregations:  https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...

"I like big aggregations and I cannot lie

You other PBI'ers can't deny"

[ericOnline]

Boom! The multiple aggregation approach worked.

ALL_LastRecord = 
    CONCATENATE(
        "Last Updated: ",
        VAR varTimestamp1 = SELECTCOLUMNS(table1,"Column",[timestamp])
        VAR varTimestamp2 = SELECTCOLUMNS(table2,"Column",[timestamp])
        VAR varTimestamp3 = SELECTCOLUMNS(table3,"Column",[timestamp])
        VAR tmpTable = UNION(UNION(varTimestamp1,varTimestamp2),varTimestamp3)
        VAR tmpValue = MAXX(tmpTable,[Column])
        RETURN tmpValue
    )

Bingo! So did @amitchandak 's approach! (Ended up going with this solution because less code)

ALL_LastRecord = 
    CONCATENATE(
        "Last Updated: ",
        VAR varTimestamp1 = MAX(table1[timestamp])
        VAR varTimestamp2 = MAX(table2[timestamp])
        VAR varTimestamp3 = MAX(table3[timestamp])
        RETURN
        MAX(varTimestamp1, MAX(varTimestamp2, varTimestamp3))
    )