Forum Discussion

Jedahn's avatar
Jedahn
Frequent Visitor
3 years ago

Dax Formula

Hello PowerBI Community,   So I have two datasource in excel. First is the "Target" table which contains the names of the customers that the employees need to call. Second is the "Actual" table tha...
BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

I would probably start with the lookup function and add rules as needed...

LOOKUPVALUE(
    <result_columnName>,
    <search_columnName>,
    <search_value>
    [, <search2_columnName>, <search2_value>]…
    [, <alternateResult>]
)