Forum Discussion
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...
Oh 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.
How would I add the filter for the company name back to the closingpricedaybeforeII measure?
I'm still curious about a time intelligence function or if its worth creating tables and then just working off that? Since the tables would be worked on when the model is created it might solve the performance issue and let us use time intelligence functions.
I'm still curious about a time intelligence function or if its worth creating tables and then just working off that? Since the tables would be worked on when the model is created it might solve the performance issue and let us use time intelligence functions.