Forum Discussion

sperry's avatar
sperry
Icon for Resolver I rankResolver I
8 years ago
Solved

Encode a Text field

Hi - I have a government issued unique identifer (called NHI in New Zealand). Its in the format ABC1234.   I have a data set that I would like to pseudonymise using a formula in query editor as I w...
Need Help
  • ImkeF's avatar
    ImkeF
    8 years ago

    You can create a lookup-table in the query editor where you do the things that you tried to achieve in DAX:

     

    - reference your original table and select just the NHI-column

    - remove duplicates

    - add index column

     

    That's your lookup-table now. Create a NEW query (!) where you reference your original table, merge with the new lookup-table on NHI, expand the index (your new key) and remove the NHI-column. Disable load to datamodel for your original table.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

You can create a lookup-table in the query editor where you do the things that you tried to achieve in DAX:

 

- reference your original table and select just the NHI-column

- remove duplicates

- add index column

 

That's your lookup-table now. Create a NEW query (!) where you reference your original table, merge with the new lookup-table on NHI, expand the index (your new key) and remove the NHI-column. Disable load to datamodel for your original table.