I have a sample table values below.
Jurisdiction Doc Type Adopts Publication Year
Alabama Amendments IBC 2021
Alabama Amendments IBC 2019
Alaska Integrated IFC 2013
My formula below only returns 1 column value
Codes.Filter(Jurisdiction=''Alabama AND [Doc Type]=“Amendments”).[Adopts Publication]
Output:
IBC, IBC
I want it to output,
[IBC, 2021],
[IBC, 2019]