We can use the powerfx experience to fetch a data from a "related" table. For example, to fetch the consumption of a specific product in for the 3.11 Use of sold product.

We then see a value to be able to fetch the Unit using the same PowerFX experience. To fetch the unit we stored in the Custom Table.

Additionnally, using the same behaviour for "reference data" and being able to use PowerFX to provide the value of the reference data (+drop down to specify table we are mapping to) would be relevant. Example, to be able to match the parent of an account in the reference table.