The problem is that for days 4, 5, 6, 7 I have more sessions with ForecastDate and ForecastTime.
I modeled my cloud with two tables Forecast, Data, because I need to have for the same FlowDate the ACT values. If I do a model with a single Data table where have ForecastDate and ForecastTime too I obtain always value 0 for ACT column.
For ACT data I have a value for single FlowDate, FlowHour, ClientID, Area.
A possible solution is to complete data for each row where Type = ACT with SessionID, ForecastDate, ForecastTime. This solution isn't the best beacuse my application contains more of 130.000.000 rows and this increase a lot the rows.