I have a fact table that is sort of a historian, I want to write a Dax measure that will give me Overdue Days.
If the Completed Column is 12/31/1899, it means the test is yet to be performed. So my first calculation is to filter Completed Date Column by 12/31/1899;
Secondly, I can now find the number of days past due or Overdue from subtracting Planned Date from Today().
Finally I need it to be placed into buckets i.e. 7 days past due, 30 days past due and > 90 days past due.
Please any help will be greatly appreciated...... and the goal is by Dax measures but calculated columns will also suffice
| Instrument Tag | Status | Service Days | Completed_Date | Planned_Date |
| AT-0014 | 99 | 14 | 7/8/2021 | 6/5/2021 |
| AT-0115 | 99 | 14 | 7/8/2021 | 6/26/2021 |
| ANALYZER-TASK-2 | 99 | 14 | 6/23/2021 | 6/26/2021 |
| ANALYZER-TASK-2 | 99 | 14 | 7/5/2021 | 7/7/2021 |
| ANALYZER-TASK-2 | 99 | 14 | 6/12/2021 | 6/7/2021 |
| ANALYZER-TR3 | 99 | 14 | 6/28/2021 | 6/16/2021 |
| ANALYZER-TR3 | 99 | 14 | 6/2/2021 | 6/3/2021 |
| ANALYZER-TR1 | 99 | 14 | 6/8/2021 | 6/10/2021 |
| AT-0201A | 99 | 14 | 6/25/2021 | 6/24/2021 |
| AT-0201A | 99 | 14 | 7/6/2021 | 7/9/2021 |
| AT-0201A | 99 | 14 | 6/10/2021 | 6/7/2021 |
| AT-2005 | 99 | 14 | 6/22/2021 | 6/22/2021 |
| PC-023A | 55 | 365 | 12/31/1899 | 6/1/2021 |
| PC-108C | 55 | 365 | 12/31/1899 | 6/5/2021 |
| ROTATING-TAGS-2 | 55 | 365 | 12/31/1899 | 6/6/2021 |
| PC-022A | 55 | 365 | 12/31/1899 | 6/6/2021 |
| PC-001B | 55 | 365 | 12/31/1899 | 6/8/2021 |
| XF-015 | 55 | 365 | 12/31/1899 | 6/22/2021 |
| TURBINE-STEAM-TR2 | 55 | 365 | 12/31/1899 | 6/22/2021 |
| TURBINE-STEAM-TR1 | 55 | 365 | 12/31/1899 | 6/22/2021 |
| PC-109B | 55 | 365 | 12/31/1899 | 7/7/2021 |
| PLANT-GEN | 55 | 365 | 12/31/1899 | 6/26/2021 |
| GAS-SYSTEM-TR2 | 55 | 365 | 12/31/1899 | 7/15/2021 |
| PC-108C | 55 | 180 | 12/31/1899 | 7/25/2021 |
