Forum Discussion
Overdue Calculations Dax
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 |
4 Replies
DAX measure assumes you will aggregate the source by PivotTable. From sample source table it's not clear which kind of aggregation it'll be, other words how DAX measure will be used.
- Thanks....this was actually a Power BI question....... I have reposted my question in the Power BI Community space
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space- please post Excel questions here in the future.
- Thanks........ yeah I realized that and asked the question in the Power BI community
