Forum Discussion

abelrmg's avatar
abelrmg
Icon for Helper II rankHelper II
6 years ago

HELP INDEX COLUMN WITH RANGES

I have a two columns "JOB" and "ROL", Job is a incremental number and "ROL" this could be "A","B" or "C". And I would like to add a column like index considering how many equals roles there are for e...
Need Help
abelrmg's avatar
abelrmg
Icon for Helper II rankHelper II
6 years ago

parry2k , thank you for your suggestion it works, but is there sometihing similar in Power Query?, beacuse then i want to create a pivot table and the values are dynamics and this does not work in DAX.

 

Regards

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago
Not sure what you mean by dynamic, it should work. May be I am missing something.
  • abelrmg's avatar
    abelrmg
    Icon for Helper II rankHelper II
    6 years ago

    parry2k It was my mistake, I forgot to mention that I was looking for the solution via Power Query, because then I will use that column to make a pivot table to perform some like this:

     

    JobROL A1ROL A2ROL B1ROL B2ROL B3ROL C1
    1Name 1Name 2Name 3  Name 4
    2NAME 5 NAME 6  NAME 7
    3NAME 8 NAME 9NAME 10NAME 11NAME 12

     

     

    Regards