Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Pull latest date with data

Hi, I have data similar to below:

 

DateABC
10/25/2022   
10/19/2022   
10/5/20221054
10/3/2022   
10/2/2022   
9/28/202233787

 

How can I pull the latest date where data is present using a measure?  Which in this case is 10/5/2022

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 ||

     



     

1 Reply

  • 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 ||