Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Pull latest date with data

Hi, I have data similar to below:   Date A B C 10/25/2022       10/19/2022       10/5/2022 10 5 4 10/3/2022       10/2/2022       9/28/2022 33 7 87   ...
Need Help
  • vojtechsima's avatar
    vojtechsima
    3 years ago

    Hello, Anonymous 

    LatestDateWithData = 
MAXX(
    FILTER('Table',  
        NOT(ISBLANK('Table'[A]) || 'Table'[A] = "") &&
        NOT(ISBLANK('Table'[B]) || 'Table'[B] = "") &&
        NOT(ISBLANK('Table'[C]) || 'Table'[C] = "")
    ),
    'Table'[Date]
)

    If you want OR instead of AND, you can change && to ||

     



     
vojtechsima's avatar
vojtechsima
Super User
3 years ago

Hello, Anonymous 

LatestDateWithData = 
MAXX(
    FILTER('Table',  
        NOT(ISBLANK('Table'[A]) || 'Table'[A] = "") &&
        NOT(ISBLANK('Table'[B]) || 'Table'[B] = "") &&
        NOT(ISBLANK('Table'[C]) || 'Table'[C] = "")
    ),
    'Table'[Date]
)

If you want OR instead of AND, you can change && to ||