Forum Discussion

ZakD's avatar
ZakD
Frequent Visitor
2 years ago
Solved

Assistance Needed with Lookup Function Issue in Power BI

Dear Power BI Community,   I hope this message finds you well.   I am currently facing a challenge with a lookup function in my table view within Power BI. Although the function operates correctl...
Need Help
  • ZakD's avatar
    ZakD
    2 years ago

    Among the solutions considered, I have selected the DAX function (MINX and FILTER). As a reminder, this is the  formula syntax:

    ---------------------------------------------------------------------------------------------------------------
    ResultColumn = MINX(
    FILTER(
    Table2,
    Table2[ID] = Table1[ID]
    ),
    Table2[ValueToLookup]
    )

     

    Thanks again HotChilli for your support, I could sort this thanks to your guidance.

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Thanks, it's helpful. You will understand why I ask for proof.

What's the datatype on the client_id? Has the type been changed at any point?

--

Test this by hardcoding the LOOKUPVALUE to look for client_id 1564.  If it returns values correctly then the client_id is not really 1564 for the rows that are not working (it might look like it but something will be amiss)