Forum Discussion
MAX value using other columns
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.
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] ) )
2 Replies
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] ) )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.
