topic Re: How to calculate daily stock return using DAX formula? in DAX Commands and Tips

How to calculate daily stock return using DAX formula?

Anonymous — Sat, 12 Dec 2020 04:39:35 GMT

Hi all,

I want to calculate the daily return for this stock price (ignoring the weekend) by creating a new measure. May I know how should I do that by using DAX formula? I'm quite new to PowerBI. Thank you.

Re: How to calculate daily stock return using DAX formula?

mahoneypat — Sat, 12 Dec 2020 14:09:49 GMT

Here is one way to do it. Use this measure expression in a table visual with the date column from your stock table. Replace Stock with your actual table name.

Change From Prev Day =
VAR thisvalue =
    MAX ( Stock[Close] )
VAR thisdate =
    MAX ( Stock[Date] )
VAR prevvalue =
    CALCULATE (
        LASTNONBLANKVALUE (
            Stock[Date],
            MAX ( Stock[Close] )
        ),
        FILTER (
            ALL ( Stock[Date] ),
            Stock[Date] < thisdate
        )
    )
RETURN
    DIVIDE (
        thisvalue - prevvalue,
        prevvalue
    )

Regards,

Pat

Re: How to calculate daily stock return using DAX formula?

pbiforum123 — Tue, 25 Apr 2023 15:48:00 GMT

mahoneypat Similar thing I need to do for Weekly and Monthly as well. Can you please help it is little urgent.

https://community.powerbi.com/t5/Desktop/stock-gainers-and-losers/td-p/3160077

Greg_Deckler Can you please help me here?

Re: How to calculate daily stock return using DAX formula?

pbiforum123 — Sat, 22 Apr 2023 11:46:54 GMT

mahoneypat Any update on the above? Can you please help?