I have attached a packaged workbook (2019.3). As you see in the image below, I want the ONLY most current Avg.MSRP Price available and the Avg Price for the filtered time period by date. Not sure how to go about this. Thank you for any assistance.
6 answers
Or if you were trying to show the columns for one measure,and only the max for one measure, you can use this calculation.
if size() = 1 then
avg(if [Date Column] =
{max([Date Column])} then ([MSRP Price, $]) end)
ELSE
AVG([Price])
END
Hope this helps! See Attached.
Please mark this answer as correct or helpful if it helps solve your question.
Robert Breen
