Machine servicing schedule

Hi @PaulBoyes. A few things right off the bat. Your model does not have a DATES table; please add one and mark it as such to enable you to use the DAX time intelligence functions in your model.

The M code for an excellent DATES table is available from Enterprise DNA:

Then, a data modelling refactor and/or a review of your data is necessary. (I noticed, for example, that there are very few records which are actually linked between your [Fans] table and your [Transform-ITData] tables.)

Once the DATES table has been added, marked as such, your model and/or data has been reviewed and revised as necessary, repost if you’re still having issues with your measures.

Greg