Hi @RyanWhite. I can see from your DAX code that it’s using …[Date].[Date]…, which suggests that you’re using the auto-date/time option and don’t have a dedicated [Dates] table that is marked as such. After disabling the Auto date/time option and verification of the [Dates] table, please attach your work-in-progress PBIX (with sanitized data, if necessary) and a marked-up screenshot or Excel mock-up of the visual for your desired outcome.
Greg
P.S.: Here are a couple of resources that might help:
