Sum of Lookup values by ID

[Anonymous]

Hi all. 
Im very new to Power BI and i´ve been lost trying to solve this for a couple of hours 😕

I need to lookup the sum of all the FCST Units and Sales Units  from the sales record table to the Sum table so i can filter from specific dates.

Sum Table

Sales Record Table:

Thanks all

[amitchandak]

@Anonymous , You can slice data only in Visual on in table so put FCST Qty and Sales QTY in visual and take date filter