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

The relations had already been disabled due to numerous circular relationships. Consequently, I utilized the lookup function to manage this complexity.

As you suggested, initially I attempted to merge the tables using an inner join, but encountered connectivity issues with my ODBC driver. Subsequently, I implemented an alternative approach using the MIN and FILTER functions, which proved to be highly effective. I plan to apply the same method to extract the remaining fields required.


Based on this experience, it seems that using MIN and FILTER functions might be a more suitable solution than relying on a lookup value for our current needs.

 

 

Thanks for your help HotChilli