Hi Sam - Wondering if you can help. I have a dim date table with date values that go all the way to December 2018. My fact sales table currently has sales data until end of June 2018.
Every week, I filter my dim date table manually to equal to the last date on the fact sales table and then load the data in the model. Hence, given my fact sales data ends at June 30, 2018, I filter my dim date table in the query view to June 30, 2018 and then load the data.
Is there an automated way (perhaps an M code) that does this functionality automatically? Also, is what I’m doing with filtering the date table proper practice or should my dax code incorporate despite a date table going until Dec 2018 (w/o filtering)?