Forum Discussion
Cut-off Date from Different Table
- 1 year ago
Hi RobRayborn - Create a calculated column or measure to identify the first order date per product.
eg:
FirstOrderDate =
CALCULATE(
MIN('Orders Taken'[DATE CREATED]),
ALLEXCEPT('Orders Taken', 'Orders Taken'[Product])
)Now write the Forecast Measure that blanks quantities after the first order
Adjusted Forecast Quantity =
VAR CurrentProduct = SELECTEDVALUE('Product'[Product])
VAR CurrentShipDate = SELECTEDVALUE('Date'[Date])VAR FirstOrderDateForProduct =
CALCULATE(
MIN('Orders Taken'[DATE CREATED]),
FILTER('Orders Taken', 'Orders Taken'[Product] = CurrentProduct)
)RETURN
IF(
NOT ISBLANK(FirstOrderDateForProduct) && CurrentShipDate >= FirstOrderDateForProduct,
BLANK(),
SUM('Forecast'[Quantity])
)Place this Adjusted Forecast Quantity measure on visuals using the Date, Product, and Forecast context.
It will show the original forecast only before any order activity started per product. Hope this works.
Hi RobRayborn
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
My appologies. I haven't had time to try the solution out yet.
Hopefully by the end of the week this week.