if and sumifs power query

[RichieRich1]

Dear all, 

Thanks for reading this and hipefully you can help me with the follow case;

what do i need;

Level 04 is lowest level, level 00 is highest level.

I need for each projectdefinition ;

total sum of budget level () - lower level (for the same project).

so that means for level 2 -->

Total sum budget level 2 by project definiion minus Total sum budget level 3 by project definiion - Total sum budget level 4 by project definiion

who can help me?

[KT_Bsmart2gethe]

Hi @RichieRich1 ,

It is unclear what you want to achieve, and sample data for one project with the desired outcome would be grateful. Your explanation makes sense, but I cannot link it to the outcome.

Regards

KT

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523