Forum Discussion
ElliotP
Post Prodigy
Post ProdigyData 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...
ElliotPPost Prodigy
Post ProdigyI've had a look again. I really can't see any difference. I've noticed you've added some test measures in both the datetable and the fact table; but I can't see their influence upon our final created measures.
hmmm
Phil_Seamark
Microsoft Employee
Microsoft EmployeeOh they may be ones I was just messing around with. I created a calculated column in your Date table to help filter (index) faster,
And two calculated columns that show the close price for Today and Last Trading Date end with II
Probably need to add back in the filter for company name. I'd suggest merging this table to the main table for performance reasons.