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.

     

Anonymous's avatar
Anonymous
Not applicable
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    we are receiving masked data so we need not add XX in the start. 

    I just changed the DAX a little and i was able to get the solution 🙂

     

    Calculated_Column :=( [Account_NO] & REPT ( " ", RANKX ( 'TableName', 'TableName'[Account_ID],, ASC, DENSE )))

     

    Hope this is correct !

    Thanks for guiding 🙂