Forum Discussion
How have the calculated table refresh when the direct query table re-queried
I created a calcuated table in Power BI named Combined (see code below). The "Actaul Direct" table is DirectQuery mode, but each time "Actaul Direct" was refreshed and "Combined" didn't. I think it m...
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.
Yes, actaully actuals, forecast, and plan. Sorry I left out plan. I thought if I resolve "Forecast", I can resolve "Plan". "Plan" has the same key as "Forecast".