Unable to use Memory table created by SUMMARIZE and ADD COLUMNS with MIN()
Hello Fellow Daxers,
I have created a table using SUMMARIZE and ADDCOLUMNS. Now I’m stumped…when I try to compute the MIN() of a column in this Memory table, I get the error:
Table variable 'SummarizeTrendsTable' cannot be used in current context because a base table is expected.
(Incidentally, I have confirmed that the SUMMARIZE and ADDCOLUMNS code works…by looking at the results if I create a “New Table” with the code. Not what I'm doing, mind you, but just to be sure I know it works)
Is it true I can’t use the MIN() function a “Memory Table”? Thank you in advance! Tom
Here’s the ADDCOLUMNS and SUMMARIZE code with the . It's a small table--about 15 rows each time it's "called".