Forum Discussion

Arancium's avatar
Arancium
New Member
3 years ago
Solved

Select Column as index

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"])...
  • eliasayyy's avatar
    eliasayyy
    3 years ago

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

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




Arancium's avatar
Arancium
New Member
3 years ago

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's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

Last Value = 

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

this should return your latest value

here is a small sample

 

  • Arancium's avatar
    Arancium
    New Member
    3 years ago

    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's avatar
      eliasayyy
      Icon for Memorable Member rankMemorable Member
      3 years ago

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

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




      • Arancium's avatar
        Arancium
        New Member
        3 years ago

        Thanks a lot for your time eliasayyy