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 = ???