Forum Discussion
ChPetru
Helper I
Helper ILookupvalue() 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...
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 _result3. The PBIX file is attached for reference.
Best Regards,
changqing
tamerj1
Community Champion
Community ChampionHi ChPetru
If this is the only blank value in the [Total Component Price] column then
New Column = COALESCE ( TableName[Total Component Price], MAX ( TableName[Total Component Price] ) )
- ChPetru
hi Tamerj, the table I have given as an example is just a small sample of a huge dataset with millions of rows, and I have multiple different Parent Products and Components. The Coalesce will not work
