Forum Discussion
Cali_2020
Helper I
6 years agoSeparate 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...
amitchandak
Super User
6 years agoI 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.