Forum Discussion

danyeungw's avatar
danyeungw
Icon for Helper II rankHelper II
3 years ago

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...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
3 years ago

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. 

danyeungw's avatar
danyeungw
Icon for Helper II rankHelper II
3 years ago

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".