Dear DNA team,
Would you mind helping me out for below scenario as I wanted to retrieve the value from the reference table seems array in excel,
There are multiple way to proceed in excel such as xlookup, etc.
However I would like to link the value from reference table to the working table.
2D modelling.pbix (32.4 KB)
scenario.xlsx (11.0 KB)
