Quarterly Data Doesn't show up properly

Hi Anonymous 

This requries a total model overhaul. I've spent 15min in this already and I keep finding issues that need to be fixed, so let me give some guidance on how to proceed.

1. You must have a legitimate date table. A date table has a date field that:
   1. has the first date in your model you need (and usually should be the first day of that year, so if the first date in your model is July 3, 2020 and you are calendar year, it should be Jan 1, 2020)
   2. Has the last date (and corresponding last day of the year, so Dec 31, 2020)
   3. Has every date between. No skips. So if it is 2020, it should be 366 rows (has leap year)
   4. You mark it as a date table in Power BI - right-click on it and Mark as Date Table
   5. Turn off Automatic Date/Time Intelligene in both Global Options and Local Options. This is critical.
2. Every measure that uses time intelligence should use that date table and date column.
3. Clean up your measures and table. You have a C table and a CALENDARDISCONNECTEDTABLE table. You should generally only have one data table, but if you have multiple, (that is ok in some circumstances) they should all be marked as a date table, and not disconnected.

There is no quick fix here. I added a date table to your model and started replacing fields using the date table, but then I got into a quagmire of trying to fix and understand the mix of measures and calculated columns and decided to respond with this advice thus far.