Forum Discussion

viralpatel21's avatar
viralpatel21
Helper II
3 years ago
Solved

Find Latest date from multiple tables

Hello Team,

 

I am trying to find the "Latest Activity Date" from 4 tables:

I created measures from each tables:

Measure:

Last Crypto Date = Max(crypto[date]) - Crypto Table

Last Balanceadjust Date = Max(balanceadjust[date]) - BalanceAdjust Table

Last Presentment Date = Max(Presentment[date]) - PresenetmentTable

Last Ledgers Date = Max(Ledgers  [date]) - Ledgers Table

 

Trying to create a measure so it looks all all 4 tables and gives me 1 date which represent "Last Acitivty"

 

Thanks

Viral 

 

Need Help
Show and Tell
Tutorial Requests
  • johnt75's avatar
    johnt75
    3 years ago

    You can use

    Last Activity Date =
MAXX (
    {
        [Last Crypto Date],
        [Last Balanceadjust Date],
        [Last Presentment Date],
        [Last Ledgers Date]
    },
    [Value]
)

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    You can use

    Last Activity Date =
MAXX (
    {
        [Last Crypto Date],
        [Last Balanceadjust Date],
        [Last Presentment Date],
        [Last Ledgers Date]
    },
    [Value]
)