Forum Discussion
huguest
Advocate II
Advocate IIIndex/Match equivalent (same query)
Hello, I am trying to add a column that will report a value from a "Parent" record that is in the same table. In Excel, I would use an Index/Match formula to achieve that, but I cannot figure out a...
You may try LOOKUPVALUE Function in DAX.
Column = LOOKUPVALUE ( Table1[Color], Table1[ID], Table1[Parent ID] )
v-chuncz-msft
Community Support
Community Support
You may try LOOKUPVALUE Function in DAX.
Column = LOOKUPVALUE ( Table1[Color], Table1[ID], Table1[Parent ID] )