Select with 2 parameters

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 :expressionless: , I’m new, I can’t get it to appear yet :face_with_monocle:)

Thank you very much for your support

2 Likes

Try it with this:

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

Thanks a lot, I’ll try it.

1 Like

Many thanks,I’ll check it out.

1 Like