Hi Matthew,
In the resources of the Advanced atea Transformations & Modelling course (link below) you’ll find the M code for a Date Table function. Most of what you’ll ever need is included but should the need arise you can customize it to better fit your needs. Like adding holidays so you can exclude them as workingdays and/or adding date offsets so you can move through time relative to TODAY’s date.
The key is that there’s just one Date table in your model - that does it all.
I’m confident you’ll resolve all issues by taking the time to create a proper Date table.