Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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]))
Proud to be a Super User!
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!
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]))
Proud to be a Super User!