DATEADD combined with filter function

Hi there,

I was wondering if anyone could help me. I'm rather new to power bi.

Essentially, I have a dynamic chart which shows how much advertising has been booked for the months ahead. The filters set in place include title group, format, on sale date, date booked and budget date.

Budget date is the revenue target for that month, date booked is when the date the advertising was booked and the on sale date is when it goes on the shelves and is publsihed. 

The  format filter includes digital and print. Print is prepared and set to publish 2 months in advance and digital one month. 

I have a visualisation which shows the revenue target based on budget date, and i would like to show that against the actual figure which is based on the date booked e.g. August and the on sale date e.g. November when it is actually published to see how much revenue is booked ahead. However, I need a formula which will basically sum the net revenue for print as two months behind and digital one month behind. Maybe it is quite simple but I have no idea.

After that on another page I would like to show a new target which would be what finished on for the month divided by what was booked for that month on the last day of the previous month.

Thanks,

I would be so grateful for your help!