INDEX EQUIV in Dax

[Ramsjo]

Hello everyone,

I try to replace a index equiv formula from an excel file in my Power BI file, but I am stuck.

This is how my table looks like :

Parameter	A	B	C	D
1	XX	WW	XX	ZZ
2	GG	FF	DD	RR
3	TT	PP	MM	LL

The idea is to find for A+1 ==> XX in another table on which I created a relationship on the parameter column.

Can you help me on it ?

Thx a lot !!

[v-chuncz-msft · Accepted solution]

@Ramsjo,

You may try using LOOKUPVALUE Function to return the value.

[v-chuncz-msft · Accepted solution]

@Ramsjo,

You may try using LOOKUPVALUE Function to return the value.

[Ramsjo · Accepted solution]

I found a solution with the look up value.

I unpivoted the columns, and then make a lookupvalue with filters 🙂

Thx a lot guys

[Yggdrasill]

Try this1234

[shebr]

 Hi @Ramsjo

If you hav made a connection to another table perhaps you can use the RELATED() function. Like @danextian has mentioned, do you have your excel formula for us to see.

Thanks

shebr

[Ramsjo]

Hello Everyone,

This is how the Excel formula looks : INDEX(Table1!$B$2:$E$3;EQUIV(Parameter;Table1!!$A$2:$A$3;0);EQUIV(ColumnName // so A B C D // ;Table1!$B$2:$E$2;0))

I will try to unpivot the columns, I keep you informed !

Thx

[Ramsjo]

Hello @shebr @danextian @Yggdrasill thx for your help,

The unpivot way erase the connection with the other table, therefore I can't do what I want after.

If you need more information or details, I'm here 🙂

[danextian]

Hi @Ramsjo,

If you were to write your formula in Excel, what would it be?