Forum Discussion
ADDCOLUMNS - please explain!
Greetings folks! I have a calculated table which contains two columns with date values. Now I wish to generate another column which calculates their difference. I am utilizing ADDCOLUMNS to ...
HI igaca
Rather than try and put the logic into your ADDCOLUMNS statement at the point you create the calculated table, why not just add a calculated column to the table once you have created it with the same logic?
Oh and further to your question as to why.
I believe the formula you are using relies on a phyiscial table, and you are adding the code part way through the creation of table so it's not yet a phyisical table.