MAX value using other columns

[Henrique_Quint]

Hey! 

I have a table that has 3 columns up to 17 (See column Ordem), but the actual data goes to most recent information (as of today, is Ordem 9, but monday will be Ordem 10).

What I want is to return the most recent Ordem that HAVE data on it, but when I try to use max value, it only returns 17.

[justinmartin · Accepted solution]

If base is the column you want to make sure there is data in, you can do something like this:

My Measure = 
CALCULATE (
    MAX ( 'Table'[Ordem] ),
    NOT ISBLANK ( 'Table'[Base] ) 
)

[Anonymous]

Hi @Henrique_Quint 

Based on your needs, I have created the following table.

Then you can use the following Measure to get the result you want:

Measure = 
VAR select_date = SELECTEDVALUE('Table'[Date])
RETURN
MAXX(FILTER('Table','Table'[Date]<=select_date&&'Table'[Estado]<>BLANK()),'Table'[Ordem])

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.