Filter by enumlist

Good day:
I have an app that records partner payments. Every time a member pays a fee or several, I select it from an enumlist that refers to a table where the months are found.
Here comes my question:
Is there a way that when selecting a partner the enumlist only shows the months that remain to be paid?

Ejemplo.png

0 1 51
1 REPLY 1

Cannot be sure of the exact expression without knowing your architecture but it would be something like the following in the Suggested Values.

 

MONTH TABLE[month] 
- 
UNIQUE(
 SPLIT(
  SELECT(
   PAYMENT TABLE[MONTHS ENUMLIST],[PARTNER]=[_THISROW].[PARTNER]
  ),
  " , "
 )
)

 

 

Top Labels in this Space