Cumulative Values between Period of Time

[JohanData]

Hi there,

Could you please help me out?

Link to the files: https://1drv.ms/u/s!AvDjQoL_zmjliHROT3e-Y6s2FSmD?e=fFX1lc

Situation:

This should be the outcome:

Thanks in advance..!

[V-pazhen-msft]

@JohanData 

I created SpendCum and Project results columns in the fact table in my solution. Since you are including columns from two tables in Power bi, you cannot leave blanks and make the table exact same as your expected outcomes.

SpendingCum = 
CALCULATE (
    SUM ( 'Fact'[SpentAmount] ),
    FILTER (
       ALLEXCEPT('Fact','Dimension'[ParentProjectNr]),
        [Date] <= EARLIER ( 'Fact'[Date] )
),
    'Fact'[Date] >= RELATED ( 'Dimension'[DateSigned] ),
    'Fact'[Date] <= RELATED ( 'Dimension'[MaxDateEndProject] )
)

Project result = 
CALCULATE (
    SUM ( 'Dimension'[Price] ) - LASTNONBLANK ( 'Fact'[SpendingCum], "" ),
    FILTER ( 'Fact', LASTDATE ( 'Date'[Date] ) )
)

Here is the pbix if needed: https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/EdXN14MBisFInuK7Lr2L... 

Best,
Paul

[JohanData]

@V-pazhen-msft thanks!

Unfortunately, this is not what I'm looking for. I reshaped my files. This should be the outcome (screenshot +attached files):

Link: https://1drv.ms/u/s!AvDjQoL_zmjliQLeHwlgFVgk6kvD?e=LRAd5i

[V-pazhen-msft · Accepted solution]

@JohanData 

I see your expected solution. It seems that is impossible to make the table exactly same as your expected outcome. You cannot have blank in the datesigned and maxenddate like your expected outcome with the features in Power BI Desktop.

Best regards,
Paul