Forum Discussion
ClemFandango
Advocate II
Advocate IIHow to calculate continuous dates
Good morning all, I have an ongoing topic to find gaps in continuous dates, but this is a slightly different problem. For this topic, I am trying to find continuous dates for each ref. Please se...
ClemFandangoAdvocate II
Advocate IIHi Mahesh0016
The calculated columns 'Continuous Start', 'Continuous End' and 'EndRank' are showing the expected/desired output at this stage. By creating a continuous start date & continuous end date I will be able to identify the date when a 'Ref' is 'New', 'Lost' or 'Returned' and this will be calculated within a date table