Home Forums Data Warehousing Analysis Services Retrieving the last non-empty value and display it for each day RE: Retrieving the last non-empty value and display it for each day

  • September 8, 2013 at 9:19 pm

    #1648429

    Sounds like you need to be loading this cube from an periodic snapshot fact table that holds a record for each day.

    Or, when querying the cube you simulate a left join: