Circular References for Date

[homee]

Hi Everyone, i want to add forecast data (top left) to our data model but i always get a circular reference which i can not solve. 

How can i associate my forecast data to a date if not like this?

[lorenzoconforti]

If you calculate your forecast in the loading script, I would just rename the Date field in the Forecast2020 table

[homee]

yes lets say i do

date as forecastdate

how can i asociate forecastdate to my mastercalendar?

[lorenzoconforti]

By looking at your data structure, I don't think it makes sense to associate it to your master calendar.

You master calendar has a granularity at a document level (i.e. the dates in the master calendar refer to what look like orders); when you forecast, the dates are related to Customer_group, so dates have a different meaning and linking the two doesn't seem right

I'd imagine you want to present the forecast at a customer level which wouldn't be associated to the order level; you effectively have multiple fact tables

I would create a second calendar 

[homee]

Yes that basically correct.

So what i want is to compare the revenue from orders grouped in customer groups.

To forecasted revenue grouped in customer groups. (that basically one value per month per customer group)

So lets say i have 1.000 orders in january via amazon with a revenue of 10.000$ i want to compare this to my one value in the forecast table lets say 15.000$ for amazon. 

Can i still do that if i choose a different date variable in the forecast table?

[lorenzoconforti]

Yes, with set analysis

In your expression you would put something like:

{<DateForecast = p(Date)>}

[homee]

I still can't get it to work.

My forecast data is now loaded with a different date variable. But when i want to compare actuals with the forecast the forecast data is not reacting to my calendar functions, it is also not matched in the graph with the date of the actuals.

[lorenzoconforti]

What is the expression behind "Netto Umsatz"?

Also, which field are you using for the Date dimension in the chart? Date or forecast date?

[homee]

Behind Netto Umsatz is a Euro Sign €.

for the graph i am using Date.

[lorenzoconforti]

What is the expression behind Netto Umsatz?

Which fields are you using to calculate it?