Forum Discussion
Issue when turning on time intelligence
Hi, Uptil last month data load, I had time intelligence enabled in data load and everything was working fine. This month's data load has a few additional rows. However, data refresh would run ou...
Thanks, I have turned off auto date/time but my memory usage issues still persist, primarily due to a iterative calculated table.
To reduce the memory consumption of the model, I want to supply part of the calculated table which relates to previous months as a offline table via import mode (Table A) and have the calculated table only calculate values for the current month (Table B). I am then trying to merge Table A and Table B via a union in DAX to create a virtual table (Table C).
However, I am running into a roadblock when trying to execute the following code:
VAR TWRX = PRODUCTX (
VALUES ( TableC[TransactionDate]),
[TWR]
)
I cant qualify TransactionDate field when referring to Table C since Table C is a virtual table. The above function used to work ok and produce the desire result when Table B was performing calculations for all historical months and I was using the following code, since Table B is physical table:
VAR TWRX = PRODUCTX (
VALUES ( TableB[TransactionDate]),
[TWR]
)
Any ideas on how to resolve this?