Calculating variable stock returns

[Anonymous]

Hi,

I would like to make a visual of top 10 stocks differences, but with variable return horizon(ie, price_today - price 2 days before, or price_today - price n days before) where n is given by a measure and can be changed in a hover.

The problem is, my data has only three columns and looks like that (example for 2 symbols)

symbol	date	close
T1	16/10/2022	100
T2	16/10/2022	95
T1	15/10/2022	98
T2	15/10/2022	90
T1	14/10/2022	30
T2	14/10/2022	40

In this case i could change a hover and get 1-day diference (setting hover to 1), 2-day diference(setting hover to 2) ...

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.
Measure:

price n day = 
VAR _N = SELECTEDVALUE ( 'Table'[date] ) - 1
RETURN
    CALCULATE (SUM ( 'Table'[close] ),
        FILTER (ALL ( 'Table' ),
            [symbol] = SELECTEDVALUE ( 'Table'[symbol] )
                && [date] = _N ) )

Difference = IF([price n day]=BLANK(),0,SUM('Table'[close])-[price n day])

Change 1 to 2 to get the difference from the previous 2 days.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly