Forum Discussion
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...
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] ) )
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] )
)