Extract stock Price

[sgurdeep]

I am creating price to book, price to sales and price to earning ratios for a stock. I have last 5 years of income statement release date. I need to extract corresponding stock price for 5 dates in last years which corresponds to yearly release income statement. I do want all 5 year data but just need a query to extract stock price for 5 dates. Which DAX formula can be used . Thanks 

[daxer-almighty]

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...

[Jihwan_Kim]

Hi, @sgurdeep 

Please try to search for how LOOKUPVALUE works in calculated measure.

Thanks.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.