Forum Discussion
Calculate active contract having missing dates
Hello, In my dataset, I have only the date where contracts change state from active to inactive or inacitve to active. The day with no change, there a no row for the contract. My problem...
amitchandak
Super User
Super UserTanguyM , Create a new column like
End Date = minx(filter(Table, [Contract] =earlier([Contract]) && [Date] > earlier([Date])),[Date]) -1
and then use one of the follwing approch to get adat for all dates