How to calculate daily stock return using DAX formula?

[Anonymous]

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.

[mahoneypat · Accepted solution]

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

[pbiforum123]

@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?

[pbiforum123]

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