Select with 2 parameters

[Juan_Gutierrez]

I am currently extracting the data from my table by date using this sentence:

Select(Historical [Ending Balance], [Date] = [_THISROW]. [Date])

I want to add one more variable to filter by two concepts, date and type, I imagine it is an AND, and the structure is similar, but my doubt goes in the sense of which command I use to make the comparison?, for this first case _THISROW , it worked very well. I want the data to be taken from an emu field (if I can get it to appear on the screen , I’m new, I can’t get it to appear yet )

Thank you very much for your support

[Steve · Accepted solution]

help.appsheet.com

AND()

Are all true?

[Juan_Gutierrez]

Many thanks,I’ll check it out.

[LeventK]

Try it with this:

SELECT(
    Historical[Ending Balance],
    AND(
        [Date] = [_THISROW]. [Date],
        [ColumnA] = [_THISROW].[ColumnA]
    )
)

[Juan_Gutierrez]

Thanks a lot, I’ll try it.