Can I suggest adding a powerful new feature to the accoMASTERDATA visual: the ability to define and generate a custom composite key using a DAX expression.

Feature Details:

Composite Key Definition:

Introduce a configuration option in the settings menu where users can define their own composite key by selecting one or more TransactionKeys.

Flexible Key Composition:

The visual should combine the selected TransactionKeys to generate a composite key dynamically—preferably using a DAX formula or expression defined by the user.

Automated Matching Logic:

The visual should include smart logic to:

Detect if the composite key exists in the Master Data Management (MDM) table.

Insert a new record if the composite key is not present.

Update the existing record if the composite key is already represented—ensuring only the changed values are updated.

Benefits:

Enables more granular and tailored data matching.

Reduces manual data prep and reconciliation steps.

Supports complex use cases involving multi-field identification in MDM.

This enhancement would significantly increase flexibility and broaden the applicability of accoMASTERDATA in real-world planning and master data scenarios.