Forum Discussion
wpf_
5 years agoPost Prodigy
How does calculated columns work in directquery?
So if i understand correctly, for import mode, calculated columns are loaded into the model during a data refresh. And once it's loaded any queries are to the calculated column stored within the loc...
- 5 years ago
wpf_ That is exactly what I think happens behind the scenes, yes.
wpf_
5 years agoPost Prodigy
Thank you.
So does that mean that every time I refresh a visual that contains a measure that references a calculated column, it queries the data source and calculates the calculated column then the measure on demand?
Greg_Deckler
5 years agoCommunity Champion
wpf_ That is exactly what I think happens behind the scenes, yes.
- wpf_5 years agoPost Prodigy
Makes sense. I guess that’s why the calculated column version I had took longer then the custom column version. Thanks!