I want to add a virtual column โZoneโ in โOrderโ table where the value is derived from โZoneโ column in a reference table โAllocationโ; based on the condition that the โPostal codeโ fits the postal code range in the reference table. E.g.
Order
Address
Postal Code
Zone <<< virtual column
Allocation
Zone
Postal Code From
Postal Code To
What is the expression to use for the virtual column?
Thanks.
Solved! Go to Solution.
Hi @christopher.looi ,
See if this works:
SORT(SELECT(Allocation[Zone],AND(
[Postal Code From]<=[_THISROW].[Zone],
[Postal Code To] >=[_THISROW].[Zone]
)))
If it doesnโt work, please post a picture of your column names/settings.
Hi @christopher.looi ,
See if this works:
SORT(SELECT(Allocation[Zone],AND(
[Postal Code From]<=[_THISROW].[Zone],
[Postal Code To] >=[_THISROW].[Zone]
)))
If it doesnโt work, please post a picture of your column names/settings.
@GreenFlux It works! Thanks!
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |