Forum Discussion
Separate date tables?
Hello! I need some help regarding current and previous period dax expressions. In our organization, we analyze variances from the most recent forecast to the previous forecast, in which all is co...
I prefer to have a single date dimension. Unless requirement forces it. The Advantage is that one can put data together. So Common dimensions allow seeing data together. Sales and Forecast fact should be separate, not all filter of sales will be used for forecasting.