Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to Solution.
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.
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.
that was it, thanks 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |