Combine Costs of Project and Subproject

[acnt_schartner]

Hello,

i have the following table:

Project_Number	Costs
100001	250000
100002	230000
1000022	35000

The 6 digit Project_Numbers are our usual projects. There are subprojects that just get an extra added number to the Project_Number (7 digits). We invoice a total amount for project and subproject and i want to compare the costs to the earnings (the subproject dont have earnings and the main-project has the earnings of both). Is there a way to create a column that sums the cost of the project and the subprojects like this?

Project_Number	Costs	SUM_Costs
100001	200000	200000
100002	180000	215000
1000022	35000	0

Thanks in advance.

[harshnathani]

Hi @acnt_schartner ,

Split your project number and sub number in Power Query.

You can then create a measure

Measure_ ProjectSUM = SUM('Table'[Costs])

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[ryan_mayu · Accepted solution]

@acnt_schartner 

please try this

Column = 
if(LEN('table'[Project_Number])=7,0,SUMX(FILTER('table',left('table'[Project_Number],6)=LEFT(EARLIER('table'[Project_Number]),6)),'table'[Costs]))