Forum Discussion

Zyg_D's avatar
Zyg_D
Continued Contributor
5 years ago
Solved

Making the lookup work.

This is my data and model: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRU0lECYTMzM6VYHaCAEVTA3NwcLGAE4oAELSwsIAJGUAFLS0ul2FgA", BinaryEncoding.Base64), Co...
Need Help
Show and Tell
Tips and Tricks
  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    Thanks BA_Pete 

     

    Zyg_D Does the following work for you?

    Column =
CALCULATE (
    MINX (
        Table1,
        RELATED ( Table3[AttributeData] )
    ),
    USERELATIONSHIP ( Table1[AttributeChild], Table3[Attribute] ),
    ALLEXCEPT ( Table1, Table1[AttributeChild] )
)
BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi Zyg_D ,

 

If you want a physical column in Table 1 then just perform a merge in Power Query on Table1[AttributeChild] and Tble3[Attribute].

 

Pete

Zyg_D's avatar
Zyg_D
Continued Contributor
5 years ago
BA_Pete wrote:

Hi Zyg_D ,

If you want a physical column in Table 1 then just perform a merge in Power Query on Table1[AttributeChild] and Tble3[Attribute].

Pete

Thank you, Pete. This would work, but not always (e.g. some tables or columns in question may be calculated in DAX). So, I would like to receive an answer in DAX or a decent explanation of why a simple lookup is nearly impossible in DAX.