cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Calculating variable stock returns

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) ...

1 ACCEPTED SOLUTION
Community Support

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

Community Support

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