Forum Discussion
Summarize data from 2 different tables
I have 3 tables as follows: TABLE DATE DATE 1/1/2020 2/1/2020 3/1/2020 ..... ..... TABLE VOLUMES DATE VOLUMES 1/1/2020 10 2/1/2020 15 3/1/2020 50 ......
As far as I am aware calculated columns are "calculated" when the model is built.
So the unless the user is rebuilding the model with some kind of parameter table you can't do what you are describing.
Depending on what you are trying to do maybe a measure is a better way to go?