Forum Discussion

henriquert's avatar
henriquert
New Member
6 years ago

LOOKUPVALUE with FILTER within RANGE

Hello guys,   I need some help with DAX logic on this one..   First an overview of the situation: I have one table ("ALERTAS") which contains various security alerts. This table is indexed by the...
Need Help
Tips and Tricks
ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

henriquert 

I created sample data for this.

you can try to create a column

Column = 
VAR _type=MAXX(FILTER('MACRO','ALERTAS'[Placa]=MACRO[VEICULO]),'MACRO'[INICIO/FIM])
return if(_type="FIM",MAXX(FILTER('MACRO','ALERTAS'[Hora de inicio]<'MACRO'[data inicio]&&ALERTAS[Placa]=MACRO[VEICULO]),MACRO[nome]),MAXX(FILTER('MACRO','ALERTAS'[Hora de inicio]>='MACRO'[data inicio]&&ALERTAS[Placa]=MACRO[VEICULO]),MACRO[nome]))

hope this is helpful

  • henriquert's avatar
    henriquert
    New Member
    6 years ago

    Thank you for the reply, ryan_mayu 

     

    I was unable to run the command due to insufficient memory..

    I forgot to mention that both my tables are enormous and contain many thousands of lines.