Forum Discussion
Need help to create a column with Real Data and planned data
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 , 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]
)
3 Replies
- ddpl
Solution Sage
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]
)