Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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,
Was able to resolve the issue using: =CONCAT(DISTINCT $(vTranslate('year_ps1d')),'|')
Where $(vTranslate('year_ps1d')) returns the data with the years.