Forum Discussion
Date Differences
Hi I have a table of 64 columns. The first column is the unique ID (known internally as 'Case ID'), the other 63 columns are milestone dates. There are 21 milstones applicable to each case and ea...
Thanks again SpartaBI - I don't have a sample dataset at the moment but the unpivoted table now looks like this:
| Case ID | Milestone | Date |
| ABC123 | Milestone 1 Due Date | 30/05/2022 |
| ABC123 | Milestone 1 Revised Due Date | 31/05/2022 |
| ABC123 | Milestone 1 Completed Date | 31/05/2022 |
| ABC123 | Milestone 2 Due Date | 31/05/2022 |
| ABC123 | Milestone 2 Revised Due Date | 01/06/2022 |
| ABC123 | Milestone 2 Completed Date | 01/06/2022 |
| ABC123 | Milestone 3 Due Date | 05/06/2022 |
| ABC123 | Milestone 3 Revised Due Date | 05/06/2022 |
| ABC123 | Milestone 3 Completed Date | 07/06/2022 |
and so on for all 12 milestones...
I've tried some different measures but my Powier BI / DAX writing skills are not very good yet. What DAX would you use?
James
Anonymous that's a good table. Will send you an example on that soon.
Please don't forget to accept the relevant messages as solutions and appreciate your kudos 🙂