Forum Discussion

Henrique_Quint's avatar
Henrique_Quint
Icon for Helper I rankHelper I
2 years ago
Solved

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...
"DAX "
"DAX Commands and Tips"
"Power BI"
  • justinmartin's avatar
    justinmartin
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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.