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...
ElliotP
8 years agoPost Prodigy
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.
ElliotP
8 years agoPost Prodigy
Feelings anyone?
I'm curious if we are able to create the ClosingPriceDayBefore measure using time intelligence functions?
I'm not sure why at the moment I'm unable to use the ClosingPrice measure as the expression in a calculate function, hmmm