Forum Discussion
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 ...
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.
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.