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 ProdigyWhen I try to apply the solution to my working pbix it shows values like "170.51" for the ClosingPriceDayBeforeII.
I have added in the Trading Day Index to the datetable.
Why aren't we able to use the time intelligence functions or perhaps create a datetime table?
Phil_Seamark
Microsoft Employee
Microsoft EmployeeYou already have a Date table and we don't need a time table.
How is your working PBIX different to the one I sent in terms of data?