Variable Input - Blank and no error - Dynamic Dropdown

[ss09]

My Expression =Concat([year_ps1d],'|')
My Desired output ='2019|2020|2021|2020|2021|2022|2023|2024|2025|2026|2027|2028|2029|2030|2031|2032|2033|2034|2035|2036|2037|2038|2039'

[Happy_Mask_Salesman]

Hi.

The expression should give the desired output. Would you mind explaining a little bit, what are you trying to achieve or share with us some screenshots? Are values from 2019 to 2039 existing in the field [year_ps1d]?

If you are not achieving your desired output, it also might be possible that is being influenced by other filters, try adding {1} to ignore user selections.

=Concat({1}[year_ps1d],'|')

Regards,

[ss09]

Was able to resolve the issue using: =CONCAT(DISTINCT $(vTranslate('year_ps1d')),'|')

Where $(vTranslate('year_ps1d')) returns the data with the years.