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...
Anonymous check this sample solution I did for one measure:
Date Differences 2022-08-09.pbix
Let me know if that is what you meant.
Hi SpartaBI - Sadly, this didn't work and my table goes blank when I add the measure.
I have a lot of different case ID's, it is not just ABC123 it also contains other case IDs, for example, DEF456, GHI789, JKL101112.
Here is a screenshot of the table in its 'unpivotted' format
Each case ID could have upto 63 milestone dates.
Many thanks
James