Forum Discussion
How have the calculated table refresh when the direct query table re-queried
Hi ToddChitt, It is a very good question. The user's request was to go back 90 days. For example, what was the numbers as of 8/3/2023 or any date. Not as of today or now. Do you have any suggestions? Thanks.
Sorry, I guess I'm not understanding the requirement. Users want to see what the data looked like as of a certain date? Why not just bring in (IMPORT mode) all the data and then slice or filter it on the report for the date desired?
What am I missing?
The key is Product+Year+Month. "Actaul Direct" can have past 90 days. For example, Producta202308 for last 14 days. That means there are 14 multiple keys in "Actaul Direct" .The key in the "Forecast" is only one Producta202308. It became one to many join instead of one to one.
IF the direct qeruy brings in one day, the join is one to one.
OK, so now that I understand your data, and forgetting the whole DIRECT QUERY vs IMPORT thing, what is the problem you are trying to solve? Why would you want to combing ACTUAL with FORECAST? Those are two different FACTS with two different granularities.
Do you want to compare ACTUAL vs FORECAST? If so, put a Date table between them.
