Create dimension list from another dimension list property

Hi,

You can auto create a new dimension from a transaction list or a dimension.

• In your source list, you need to identify each new item in a new property called “item ID” for example and using a unique integer through an input or a formula (that is the most complex part).
  
  → If the source list is a dimension, you have to generate an ID using a formula, but you can also explore the subset feature
  
  → If the source list is a transactional list, with multiple occurences of the same item, I give you a formula in case it helps. 
  CUMULATE(1[ADD: 'Source list'][FILTER: CUMULATE(1[ADD:'Source list'], 'Source list' ON RANK ('Source list'.'item name'), 'Source list'.'item name') = 1], 'Source list')[FILTER: CUMULATE(1[ADD:'Source list'], 'Source list' ON RANK ('Source list'.'item name'), 'Source list'.'item name') = 1]
  This attributes a cumulated integer to each new item on the list.
   
• Then, create a new dimension, add an “ID” integer auto-generated unique property and provision 10, 50, 100, 500, X new blank items according to the expected size of your new dimension.
   
• Finally, in the Name property of your new dimension, you just call the IDs to match and render the items text:
  MATCH('New dimension'.ID, 'Source list'.'item ID').'item name'

Hope that helps.

Hi, in another post, I made a quick example of using IDs to create automatically create a new dimension:

Good luck!