Forum Discussion
ElliotP
8 years agoPost Prodigy
Data from Measure for Last Trading Day
Afternoon, I've attached a pbix for anyone that wants to have a look. I've created a measure called [ClosingPrice] which calculates the last Stock price from my dataset for each day (Fact tab...
Phil_Seamark
8 years agoMicrosoft Employee
HI ElliotP
We can definitely make this faster.
The reason I include the company name is that I assume there might be other companies and you want to track the closing price per company.
ElliotP
8 years agoPost Prodigy
Phil_SeamarkThere are. So the filter context wouldn't determine that naturally?
- Phil_Seamark8 years agoMicrosoft Employee
Not if we are clearing all the filters from the context using the ALL function
- ElliotP8 years agoPost Prodigy
hmmm
- Phil_Seamark8 years agoMicrosoft Employee
Please try this PBIX file to see if it is faster