Solved: Arithmetic expression using Select() - Page 2

AlejandroCamach · 04-17-2019 03:43 PM

Hi,

I’m trying to make a Valid_if function to restrict the maximum value from another table. I have the following formula:

MAX(SELECT(GLOSARIO INVENTARIO[Máximo], AND([_THISROW].[Frecuencia] = [Frecuencia], [_THISROW].[Punto de venta] = [Lugar], [_THISROW].[Momento] = [Momento])))

It says the formula is ok but it is not a expected Valid If condition. Any thoughts?

LeventK

@AlejandroCamacho
Valid_if needs to evaluate to a TRUE/FALSE value. You can maintain this simply:

[_THIS]<=MAX(SELECT(GLOSARIO INVENTARIO[Máximo], AND([_THISROW].[Frecuencia] = [Frecuencia], [_THISROW].[Punto de venta] = [Lugar], [_THISROW].[Momento] = [Momento])))

View solution in original post