Need help to create a column with Real Data and planned data

[Anonymous]

Hello, i need help to create a column (or a measure) that can make an "estimated Production" value with all Real data available and for future days of the month, takes planed data so you can have a value estimated if we are going ok or not with production by the end of the month. 

So in this image, new column or measure should be real data from 1 sep to 8th sep, and from 9th sep to 30th sep, use the planned data. 

How can i achieve that with DAX ??

thank you a lot in advance, it would help me a lot.

[Anonymous]

i did it thank you

[ddpl · Accepted solution]

@Anonymous , Create a calculated column as written below,

Estimated Production = 

SWITCH(
    TRUE(),
    'Table'[Date] >= DATE(2022, 9, 1) && 'Table'[Date] <= DATE(2022, 9, 8), 'Table'[Real Production],
    'Table'[Date] >= DATE(2022, 9, 9) && 'Table'[Date] <= DATE(2022, 9, 30), 'Table'[Plan Production]
)

[Anonymous]

Thank you, it worked, now how can i make it more general, for Last Date with Real data and First day of any month? 

i'm guessing I need a Measure to determinate last date with real data