It’s hard to say with confidence without seeing your data model or PBIX, but generally speaking I tend to handle these sorts of problems by relying heavily on the offset fields in @Melissa’s awesome Extended Date Table.
If you’re not familiar with that approach, she did an excellent video on it a while back explaining how offsets can be used to solve a wide range of time intellgence problems.
I hope this is helpful.
- Brian