Pull latest date with data

[Anonymous]

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

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

[vojtechsima · Accepted solution]

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