p1

 = if [Date] >= List.Min(Table.SelectRows(SprintTable, each [StartDate] <= [Date] and [EndDate] >= [Date] and [SprintName] <> null)[StartDate]) and

[Date] <= List.Max(Table.SelectRows(SprintTable, each [StartDate] <= [Date] and [EndDate] >= [Date] and [SprintName] <> null)[EndDate]) then Text.Combine(Table.SelectRows(SprintTable, each [StartDate] <= [Date] and [EndDate] >= [Date] and [SprintName] <> null)[SprintName], ", ") else null ============= = if [Date] >= List.Min(Table.SelectRows(IterationsTable, each [Start Date] <= [Date] and [End Date] >= [Date] and [Sprint Name] <> null)[Start Date]) and [Date] <= List.Max(Table.SelectRows(IterationsTable, each [Start Date] <= [Date] and [End Date] >= [Date] and [Sprint Name] <> null)[End Date]) then Text.Combine(Table.SelectRows(IterationsTable, each [Start Date] <= [Date] and [End Date] >= [Date] and [Sprint Name] <> null)[Sprint Name], ", ") else null