Forum Discussion

Shelley's avatar
Shelley
Post Prodigy
8 years ago
Solved

How to create a new dynamic table when LOOKUPVALUE function doesn't work?

I've used the LOOKUPVALUE function a number of times in the same table to create new columns and so I know it works. I have checked and double-checked my nomenclature and it appears to be correct. I'...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    Shelley

    What is the relationship between audit and procedures? If there's proper one to many relationship, you can get the procedure name with RELATED.

    Table =
ADDCOLUMNS (
    FILTER (
        'Audits Table',
        'Audits Table'[employeerelatedprocedureID] <> BLANK ()
    ),
    "pname", RELATED ( Procedures[PROCEDURES_name] )
)

     

     

     

    If this is not your case, could you post more details, sample data for each table, relationship etc.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago

Shelley

What is the relationship between audit and procedures? If there's proper one to many relationship, you can get the procedure name with RELATED.

Table =
ADDCOLUMNS (
    FILTER (
        'Audits Table',
        'Audits Table'[employeerelatedprocedureID] <> BLANK ()
    ),
    "pname", RELATED ( Procedures[PROCEDURES_name] )
)

 

 

 

If this is not your case, could you post more details, sample data for each table, relationship etc.