Forum Discussion

quantfinRguy's avatar
quantfinRguy
Frequent Visitor
8 years ago

LASTDATE issues

I have a date table ('Date Table'[Date]) connected to a date column of irregular start dates ('Table'[Date]).   For example, the irregular start dates could be: 1/31/2017 4/30/2017 8/31/2017   ...
Need Help
mattbrice's avatar
mattbrice
Solution Sage
8 years ago

What's the full measure you are using? 

 

And keep in mind that LASTDATE is a table function which will transition a row context to a filter context....so having said that, you may want to use MAX ( 'Date Table'[Date] ) instead.

quantfinRguy's avatar
quantfinRguy
Frequent Visitor
8 years ago

For all intents and purposes, the full measure is just LASTDATE('Date Table'[Date]), which in this case returns the same thing as MAX()

 

If I have my date slicer set for all dates on or before 9/30/2017, you would expect LASTDATE() to return 9/30/2017 on the date table.

However, in this case, it returns 8/31/2017 because it is last date that appears. 

 

I should note that I am using a calculated column rather than a measure. 

 

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    can you share your measures/calc column and sample data, and also relationship model. it will help to debug

  • mattbrice's avatar
    mattbrice
    Solution Sage
    8 years ago

    Calculated column for what part?  You are keeping in mind that Calculated columns are computed during data refresh, and not at run time.   A slicer based on a calculated column is fine; but a slicer won't trigger a re-calculation of a calculated column.