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
Solved! Go to Solution.
Many thanks,I’ll check it out.
Try it with this:
SELECT(
Historical[Ending Balance],
AND(
[Date] = [_THISROW]. [Date],
[ColumnA] = [_THISROW].[ColumnA]
)
)
Thanks a lot, I’ll try it.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |