Forum Discussion

efowler's avatar
efowler
Helper II
5 years ago
Solved

How to Aggregate based on DateDiff Column?

Hi, I am trying to show a line chart in Power BI based on a DateDiff column.    The example in Excel is attached as well as how it currently looks in Power BI.   Any suggestions on how I can do a Sum...
Need Help
  • richbenmintz's avatar
    richbenmintz
    5 years ago

    Hi here is what I think gets you what you are looking for

     

    Cummulative R1000 = 
	CALCULATE(
		[R1000], 
			filter(
                                allselected('warranty'[MIS]), 'warranty'[MIS]<=max('warranty'[MIS])
                     )
)

     

    Also find the updated pbix

richbenmintz's avatar
richbenmintz
Resident Rockstar
5 years ago

Hi here is what I think gets you what you are looking for

 

Cummulative R1000 = 
	CALCULATE(
		[R1000], 
			filter(
                                allselected('warranty'[MIS]), 'warranty'[MIS]<=max('warranty'[MIS])
                     )
)

 

Also find the updated pbix