Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Masked Data getting added up

Hi Team, i ran into a situation where i had to mask the account Number and display the masked account number against the balance available for them.    How the data is actually before masking:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You can try my calculated column to mask the data. It distinguishes Account Number by adding a space after it.

    Masked Account Number =
"XX" & RIGHT ( [Account Number], 4 )
    & REPT ( " ", RANKX ( 'Table', 'Table'[Account Number],, ASC, DENSE ) )

     

    Then Account ID 1 and Account ID 3 will not be merged.

     

    You can check more details from here.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.