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
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-query
and after you'll get the table like :
you can create a simple measure for summarizing only the first row of every project:
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 Rita - i have one follow up. Now the data doesn't sit within one single table. It's like this
Would you be able to show me how would you do it now? Thank you.
Also i am not able to find the add index in the PowerBI UI. Could you show me? Thanks
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.
00.cashflow =if(HASONEFILTER('Sheet1'[Strategy]),SUMX( SUMMARIZE('Sheet1','Sheet1'[Project],"Max strategy",max('Sheet1'[Strategy]),"CF1",sum('Sheet1'[CF1])),[CF1]),CALCULATE(sum('Sheet1'[CF1]),'Sheet1'[Index]=1))Thanks