Forum Discussion

ElliotP's avatar
ElliotP
Post Prodigy
8 years ago

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...
Need Help
Show and Tell
Tutorial Requests
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Not if we are clearing all the filters from the context using the ALL function

ElliotP's avatar
ElliotP
Post Prodigy
8 years ago

hmmm

    • ElliotP's avatar
      ElliotP
      Post Prodigy
      8 years ago

      When 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's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        You 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?