Issue in formula

Hi, I have a problem with a formula.

In my table I have a column called people involved in the deal. The output for the cells in this column must be the count unique of people . The formula is as follows. The problem is that I can’t relate the delivery date range to the values ​​present in the people involved on deal.

Let me explain with an example: if I select a range as the delivery date of the last seven days I will certainly have some people involved. With the formula that I have, now, in the column of people involved is shown all the people involved for all the tasks of that deal. without filtering it by the delivery date. How can I modify the formula so that it finds the selected range on the delivery date?

This is the formula:

[Import - Deals]
.Filter(
[Deal name] = thisRow.[Deal name]
)
.[Task associati]
.Filter(
[Data consegna] >= min([Select Data consegna]) AND [Data consegna] <= Max([Select Data consegna])
)
.Operativo.CountUnique()

Dear @Alessio_Cassamagnaga ,
is there a chance that you can share the doc or maybe share a light-weight copy without personal data?
Without that, it is very hard to give you tipps for your formula.
Best
Daniel

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.