Forum Discussion

ChPetru's avatar
ChPetru
Icon for Helper I rankHelper I
4 years ago
Solved

Lookupvalue() Returns Multiple Values Vetically in SAME table

Hello,   I am strunggling to find a way for this to work for 3h with no luck, it seems so simple but proves to be impossible.    I just want to bring the Total Component Price from ANY Comp...
DAX
Help
LOOKUPVALUE
measure
  • changqing's avatar
    changqing
    4 years ago

    Hi ChPetru ,

     

    I can't download the PBIX file because of the network. 

    1. How about using up-fill in Power Query Editor?

    Here's the result:

    2. Or new a calculated column:

     

    Column = 
VAR _lookupvalue =
    LOOKUPVALUE (
        'Table 2'[Total Component Price],
        'Table 2'[Parent ID], 'Table 2'[Line ID]
    )
VAR _result =
    IF (
        'Table 2'[Parent ID] <> BLANK (),
        'Table 2'[Total Component Price],
        _lookupvalue
    )
RETURN
    _result

     

    3. The PBIX file is attached for reference.

    PBIX file 

     

    Best Regards,
    changqing

changqing's avatar
changqing
Icon for Resolver II rankResolver II
4 years ago

Hi ChPetru ,

 

I can't download the PBIX file because of the network. 

1. How about using up-fill in Power Query Editor?

Here's the result:

2. Or new a calculated column:

 

Column = 
VAR _lookupvalue =
    LOOKUPVALUE (
        'Table 2'[Total Component Price],
        'Table 2'[Parent ID], 'Table 2'[Line ID]
    )
VAR _result =
    IF (
        'Table 2'[Parent ID] <> BLANK (),
        'Table 2'[Total Component Price],
        _lookupvalue
    )
RETURN
    _result

 

3. The PBIX file is attached for reference.

PBIX file 

 

Best Regards,
changqing