Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX, lookupvalue

Hi all,    I need help with the following:   I have two tables in Power BI. The first table, "GSS", has a column "Overall Index" that shows the raw index score of employees for each month. I crea...
DAX
LOOKUPVALUE
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous The equivalent of VLOOKUP is LOOKUPVALUE or using MAXX(FILTER(...),...)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Greg_Deckler

Apologies, but yes it works. I had initially tried Lookupvalue but I had a wrong understanding of it and thought that you had to utilise multiple IF and Lookupvalues such as the code below:

 

if(GSS[Average of Overall Index] < first row value of 'GSS Reference Pt Table'[Index], first row value of 'GSS Reference Pt Table'[Point], if(GSS[Average of Overall Index] < second row value of 'GSS Reference Pt Table'[Index], second row value of 'GSS Reference Pt Table'[Point]))

 

The working code if anyone is wondering:

 

Weighted Avg GSS Points = (LOOKUPVALUE('GSS Reference Pt Table'[Point],'GSS Reference Pt Table'[Index], rounddown(GSS[Average of Overall Index],2))