Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to calculate daily stock return using DAX formula?

sw40_0-1607747473239.png

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.

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.