Hi Everyone and Sam,

I am trying to create two dax formulas then try and combine the results.

Formula 1 is as follows:

This is a simple formula that just provides me with average sales of each month across each year and works as desired.

Formula 2: i am having trouble creating this formula - i am trying to calculate my sales experienced this year ONLY. E.G if the year is 2018 i only want sales from january -> now().

I then want to combine these two formulas to create a prediction. If the year is 2018 and the current month is august i want the actual values in formula 2 to be displayed up until august and then the following months have the numbers from formula 1 as a prediction to give me one trend line

any help is appreciated,

cheers