Table with the list of values ​​that meet a condition

[EmilioMadrid]

Hi,

I've got datas like:

And a Filter as:

According to this, I'd like to get the list of lines whose start and end dates include the selected date.

So, in my example I'd like to get something like:

I'm trying to do a measure like:

Lineas = CALCULATETABLE(

VALUES(Lines[Lines])

,filter(Lines,Lines[DateStart]<=min(Calendario[Date]))

)

But, of course, it says it returns a table when a simple value was expected. So It doesn't work.

How must I do it? Could you help me?

Thanks in advance.

[Greg_Deckler · Accepted solution]

@EmilioMadrid Sounds like you want a Complex Selector: The Complex Selector - Microsoft Power BI Community

[EmilioMadrid]

Hi, @Greg_Deckler . It worked perfectly.

Thanks a lot!.

Best regards.