Anonymizing certain data / Dynamic data masking

Hi ryanem thank you posting this interesting problem. 

Lets try to achieve this with help of Power Query and Dax

Here is sample data: Update your email address 

Save this data into a csv file and the go to power query create a blank query and pest this m-code 

let
    // Step 1: Load your source data
    Source = Csv.Document(
        File.Contents("D:\Community\Dynamic Data Masking\Employee_Performance_Data.csv"),
        [Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]
    ),
    
    // Step 2: Promote headers and set data types (FIXED: was EmployeeData, now Source)
    PromotedHeaders = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    ChangedType = Table.TransformColumnTypes(PromotedHeaders,{
        {"EmployeeID", Int64.Type}, 
        {"Name", type text}, 
        {"Email", type text}, 
        {"Performance Score", Int64.Type}, 
        {"Department", type text}
    }),
    
    // Step 3: Add Index column starting from 1
    AddedIndex = Table.AddIndexColumn(ChangedType, "Index", 1, 1, Int64.Type),
    
    // Step 4: Create anonymous name pattern
    AddedAnonymousName = Table.AddColumn(AddedIndex, "Anonymous Name", 
        each "Employee " & Text.From([Index]), type text),
    
    // Step 5: Create department-based anonymous names (optional)
    AddedDeptAnonymous = Table.AddColumn(AddedAnonymousName, "Dept Anonymous Name", 
        each [Department] & " Employee " & Text.From([Index]), type text),
    
    // Step 6: Create consistent sorting order (important for anonymization)
    SortedData = Table.Sort(AddedDeptAnonymous,{{"EmployeeID", Order.Ascending}}),
    
    // Step 7: KEEP ALL COLUMNS for DAX solution (don't remove Name and Email)
    // We need Name and Email for USERPRINCIPALNAME() logic in DAX
    FinalColumns = Table.SelectColumns(SortedData,{
        "EmployeeID", 
        "Name", 
        "Email", 
        "Anonymous Name", 
        "Dept Anonymous Name",
        "Performance Score", 
        "Department"
    })
in
    FinalColumns

Note: You need to update the source 

Now, Lets write a dax to get the Display Name not users name or email address 

Dax Measure: 

Display Name = 
VAR CurrentUser = USERPRINCIPALNAME()
VAR SelectedEmail = SELECTEDVALUE(EmployeeData[Email])
VAR ActualName = SELECTEDVALUE(EmployeeData[Name])
VAR AnonymousName = SELECTEDVALUE(EmployeeData[Anonymous Name])
RETURN
IF(
    SelectedEmail = CurrentUser,
    ActualName & " (You)",
    AnonymousName
)

Create a Table visual: with these columns 

As you noticed, its making all users records as Anonymous (Employee 2,3,4) expcept current user (my name). 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!