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"])

 

)

Example table:

IndexABCDE
112311241xdasdasda
223121241xdsadasda
3412411241xdasdsaa

 

Hope anyone could give me a hand thanks!!

  • 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])))




8 Replies

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    go to powerquery 

    press on add columns in the ribbons

    add index column

     



    • Arancium's avatar
      Arancium
      New Member
      3 years ago

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

      • eliasayyy's avatar
        eliasayyy
        Icon for Memorable Member rankMemorable Member
        3 years ago

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

  • 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 !