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.

ZakD's avatar
ZakD
Frequent Visitor
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.