title: PowerBI Comparable to DataStruct
body: <p>I am more used to programming than clicking button in a tool, but the &quot;Microsoft Language&quot; misses for me some essential tools for working.</p>
  <p>I got a Database which has some Old Conventions of a Primary Key Number which is essential for handling the Data. To ensure that the Convention is the right one I want to check every Element of this Colum with a Table/HashMap or something similiar to check if the Element exists in this table and change it then to a linked Value.</p>
  <p>Like in a Hashmap...</p>
  <p>[ValueColum]Compare to Key --&gt; If True --&gt; [ValueColum]= HashmapKey</p>
  <p>I searched the docs and Internet and sadly didnt find a solution, i thought i got one when I found the &quot;Record&quot; tool from Microsoft but this doesnt work since it can't compare the whole datastruct to a Colum, or may i miss there something?</p>