Forum Discussion

James__'s avatar
James__
Icon for Helper I rankHelper I
1 year ago
Solved

Dax to Indentify Sales Manager

Hi,   I have two tables 'Sales' and 'Sales People'.    The 'Sales' table contains a 'SalespersonID' field where we capture their unique ID, but some put their initials instead, which means we the...
Need Help
  • techies's avatar
    techies
    1 year ago

    Hi James__ please try this calculated column

     

    EffectiveSalespersonID =
    IF (
        'Sales'[IsValid] = 1,
        'Sales'[SalespersonID],
        LOOKUPVALUE (
            'Sales People'[ManagerID],
            'Sales People'[Department],
            'Sales'[Department]
        )
    )
     
     
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi James__ 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


Thank you.