Forum Discussion

Faber13's avatar
Faber13
Icon for Helper II rankHelper II
3 years ago
Solved

first code value

hello guys, I need to reproduce the result below in power bi   codigo       valor       resultado 10 50 50 10 50   10 50   20 100 100 20 100   20 100   20 ...
Need Help
Tips and Tricks
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Faber13 ,

     

    Please try:

    First add an index coolumn:

    Then add a column:

    resultado = IF([Index]=MINX(FILTER('Table',[codigo]=EARLIER('Table'[codigo])),[Index]),[valor])

    Final output:

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Faber13 ,

 

Please try:

First add an index coolumn:

Then add a column:

resultado = IF([Index]=MINX(FILTER('Table',[codigo]=EARLIER('Table'[codigo])),[Index]),[valor])

Final output:

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Faber13's avatar
    Faber13
    Icon for Helper II rankHelper II
    3 years ago

    that was it, thanks 🙂