Create a measure that returns existing values before TODAY() and forecasted values after TODAY()

[mdatmain]

I have a column sales total per day from the start of the year until now (4/22/2021). Then I have projected sales all year from beginning to end (Jan 1 -> Dec 31).

I want to create a new column or measure which is a combination of both of these columns, where all the values before today are the actual daily sales, and all the values after today are projected daily sales, so I can plot the projected cumulative sales forecast. I just am very new to DAX and have no idea how to implement it here.

I would think to get the before today values with DATESINPERIOD(MIN('Table'[Date]), TODAY()), and projected values after today with DATESINPERIOD(TODAY(), MAX('Table'[Date]). But not sure how to combine. 

YTD PROJECTION = 
VAR NeedHelpWithMeasure = ???

RETURN CALCULATE(
    SUM(NeedHelpWithMeasure),
    DATESYTD( 'Table'[Date])

)

[Jihwan_Kim · Accepted solution]

Hi, @mdatmain 

Please check the below picture and the sample pbix file's link down below.

I create a sample that hopefully suits your requirement.

All measures are in the sample pbix file, and all steps are numbered in front of each measure.

https://www.dropbox.com/s/0h784sgfpiznyyc/mdatmain.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/