Forum Discussion
How to aggregrate data with multiple tagging
Hi Anonymous
You can add an index column by project level using the linked method:
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-queryand after you'll get the table like :
you can create a simple measure for summarizing only the first row of every project:
Cf_ = CALCULATE(sum('Table'[Cf]),'Table'[Index]=1)Result :
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
1. You need to merge the tables to get 1.
Please check this guide :
https://www.youtube.com/watch?v=m4feUpoDpVI2. According to the index it is not a part of UI.
you have to create it. I gave the link to the guide in my first response :
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-queryIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
As you can see. If i pick all strategy, it's correct, if i pick X, Y, Z individually it's correct. However when I pick y&z it's giving me the wrong result. Thanks
Underlying excel
| Date | Project | Strategy | CF1 | CF2 | Index |
| 01/01/2024 | A | x | 100 | -100 | 1 |
| 02/01/2024 | A | x | -200 | 1 | |
| 03/01/2024 | A | x | 200 | -300 | 1 |
| 01/01/2024 | A | y | 100 | -100 | 2 |
| 02/01/2024 | A | y | -200 | 2 | |
| 03/01/2024 | A | y | 200 | -300 | 2 |
| 01/01/2024 | A | z | 100 | -100 | 3 |
| 02/01/2024 | A | z | -200 | 3 | |
| 03/01/2024 | A | z | 200 | -300 | 3 |
| 01/01/2024 | B | x | 100 | -100 | 1 |
| 02/01/2024 | B | x | 200 | -200 | 1 |
| 03/01/2024 | B | x | 200 | -300 | 1 |
| 01/01/2024 | B | y | 100 | -100 | 2 |
| 02/01/2024 | B | y | 200 | -200 | 2 |
| 03/01/2024 | B | y | 200 | -300 | 2 |
| 01/01/2024 | c | Z | 100 | 400 | 1 |
| 02/01/2024 | c | Z | 100 | 400 | 1 |
| 03/01/2024 | c | Z | 100 | 400 | 1 |
my cashflow formula.
Thanks
Hi Anonymous
I apologize, but with all the scrolling through the images, I’m having trouble understanding what you were trying to achieve and what you’ve done. The only thing I noticed is that the index doesn’t seem to be done correctly. I suggest creating a file with an example and the desired result, and including a link to it—perhaps even in a new, clean post