Select Column as index

[Arancium]

Hello,

I have a table that already have an index column. I want to keep it this way. How can i do it?

(I want it to be like like on padas .

df = pd.read_csv("file.csv, index_col= ["index"])

)

Example table:

Index	A	B	C	D	E
1	1231	1241	xd	asdasd	a
2	2312	1241	xd	sadasd	a
3	41241	1241	xd	asdsa	a

Hope anyone could give me a hand thanks!!

[Arancium]

Some background about what i'm tryng to do.

I'm trying to get the last value from a colum using this DAX

LastPS1 = LASTNONBLANK(Promedios[PS1], Promedios[PS1])

The problem is when i use this code i got the MAX value instead the LAST value. I think it is because power BI its not getting the index i set

[eliasayyy]

Last Value = 

Calculate ( MAX(Promedios[PS1]) , FILTER(Table, [index] = max[index]))

this should return your latest value

here is a small sample

[Arancium]

I'm having an issue with the code:

LastPS1 = ( MAX(Promedios[PS1]) , FILTER(Promedios, [Índice] = MAX(Promedios[Índice])))

The error is The '( )' operator or expression is not supported in this context. 

Thanks for your time @eliasayyy !

[eliasayyy · Accepted solution]

hello you forgot to add calculate in the start before the (MAX

Measure = CALCULATE( MAX(Promedios[PS1]) , FILTER(Promedios, [Índice] = MAX(Promedios[Índice])))

[Arancium]

Thanks a lot for your time @eliasayyy 

[eliasayyy]

go to powerquery 

press on add columns in the ribbons

add index column

[Arancium]

This way i create a new column. I need to use the original named index

[eliasayyy]

when you import your table it should get imported too can you please explain more