Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX variable how to

I have the following datasets: 1) Calendar   2) Actual: captures actual monthly sales Month Value Jan 1000 Feb 1200 Mar 800 etc     3) Forecast: captures forecast sales f...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

I'm not quite clear about the problem, as your description "Relationship with Calendar set for #2-3", do you mean the Calendar table have relationship with Actual table and also Calendar table have relationship with Forecast table? If so, which column are they connected, there's not date column in Actual and Forecast tables. Besides, I create a sample and attach it below, could you please reproduce your problem in my sample and send back.

 

Best regards,

Community Support Team_yanjiang