forecast data in same visual

[SivaMani]

Hi,

I wanted to show forecasted values along with actuals in a line chart.

Here are the details,

Relationship:

Date -> Actual Table

Date -> Forecast

Visual:

Added 'Date'[Date] in X axis and 'Actula Table'[Actuals] in Y axis.

Slicer - Between:

'Date'[Date]

Now I wanted to add forecast data to the visual which has data for the next 2 weeks.

Thanks in Advance!

[v-xicai]

Hi @SivaMani  ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @SivaMani ,

Based on the Cross filter direction of the relationships among three tables as Both instead of Single, you can try to create measure like DAX below.

Forecast 2 week= CALCULATE(SUM(Forecast[sales]),FILTER(ALLSELECTED(Date),WEEKNUM(Date[Date]) =WEEKNUM(MAX(Date[Date]))+2))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.