Hello, I need your help with a formula.
Im trying to get all the value from another table and next count how many they are for a year.
I added a virtual column [Selection CP] (list) :
=SELECT(Rapport Client[Date entretien :], LEFT([code postal :], 2) = [_THISROW].[Dept], [Date entretien :]>“01/01/2017”)
and another [Nbr Rapport CP] (number) to count the previous virtual column :
But i get all the value, not only the one who was made after 01/01/2017
Could you help me please?