Pulling my hair out trying to work out how to make the evaluation context work properly.
I’m trying to work out and display
- Date of the most recent sale; and
- Calculated price per unit of the item(s) bought in that sale.
I’ve got a fairly standard sales table, a simplified redacted version is below:
it works but if i were to take the detail level away, eg Invoice_NUMBER I’d get the wrong result.
The max value for the price should be date 7/5/2019, price 94.35 but i get the numbers as displayed on the total line, eg price of 109.98
The ASP SELL CURRENCY formulais below:
ASP SELL CURRENCY =
SUM ( COMBINED_SALES_PLAN[CURR_REV] ),
SUM ( COMBINED_SALES_PLAN[QUANTITY] ),
FILTER ( COMBINED_SALES_PLAN, COMBINED_SALES_PLAN[TYPE] = “ACTUAL” ),
FILTER ( COMBINED_SALES_PLAN, COMBINED_SALES_PLAN[DATE] = [Date of Last Sale] )
Going a little crazy here; would greatly appreciate any help!!!
Scheme and data below: