Valid if expression not valid entry

reggieneo
Participant V

Hi,
What is the right expression to allow me to edit the [Name] column?
This expression in valid if is what I am using to limit the name and remove in the list what is already on the list.
All works well until I edit and it is throwing invalid entry. Please assist.

(
  SELECT(
    Dipstick[Pump 1 Attendant],
    AND(
      ([Date] >= [_THISROW].[Date Start]),
      ([Date] <= [_THISROW].[Date End])
    )
  ),
       + SELECT(
    Dipstick[Pump 2 Attendant],
    AND(
      ([Date] >= [_THISROW].[Date Start]),
      ([Date] <= [_THISROW].[Date End])
    )
  )
        + SELECT(
    Dipstick[Cashier],
    AND(
      ([Date] >= [_THISROW].[Date Start]),
      ([Date] <= [_THISROW].[Date End])
    )
  )

)
    -
Select(Salary[Name],AND(
      ([Date Start] >= [_THISROW].[Date Start]),
      ([Date End] <= [_THISROW].[Date End]),True))
0 3 228
3 REPLIES 3

Maybe the below, even though not tested it. Changes highlighted in bold.

IFS(
ISBLANK( FILTER( โ€œSalaryโ€, AND([_THIS] = [Name] ,([Date Start] >= [_THISROW].[Date Start]),
([Date End] <= [_THISROW].[Date End]) ) ) - LIST([_THISROW])) ,

(
SELECT(
Dipstick[Pump 1 Attendant],
AND(
([Date] >= [_THISROW].[Date Start]),
([Date] <= [_THISROW].[Date End])
)
),

  • SELECT(
    Dipstick[Pump 2 Attendant],
    AND(
    ([Date] >= [_THISROW].[Date Start]),
    ([Date] <= [_THISROW].[Date End])
    )
    )
  • SELECT(
    Dipstick[Cashier],
    AND(
    ([Date] >= [_THISROW].[Date Start]),
    ([Date] <= [_THISROW].[Date End])
    )
    )

)

Select(Salary[Name],AND(
([Date Start] >= [_THISROW].[Date Start]),
([Date End] <= [_THISROW].[Date End]),True)),

FALSE

)

Based on the expression mentioned at the last on avoiding duplcates in the article below

Iโ€™ll Check Suvrutt and revert. Thanks so much.

Thank you. Yes, please do revert.

Top Labels in this Space