Forum Discussion
Faber13
Helper II
3 years agofirst 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 | 100 |
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.
2 Replies
- v-jianboli-msft
Community Support
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
Helper II
that was it, thanks 🙂