Not being able to get the value from the first date

[tfraletti]

Hi,

I'm trying to get the value from the first date of a stock. This is the first step in order to compute the variation between today and first day of the series (so the formula bellow is the denominator). The problem is i'm not being able to ignore the filter context provided by the visual on the date column, so i'm getting the row level value everytime. Can someone help me pointing what am i doing wrong?

first_day_value = 
CALCULATE(
    AVERAGE('yahoo finance'[close]),
    FILTER(
        ALL('yahoo finance'[date]),
        MIN('yahoo finance'[date])
    )
)

[rfigtree]

i must have deleted my first post, doing again.

the Min function will be scanning the original data model context, not the whole thing as you aree expecting.

I would do this.

var FirstDate=

calculate(min(table[date]),all(table))

return calculate(average(table[close]),filter(all(table),table[date]=FirstDate))