Forum Discussion

efowler's avatar
efowler
Icon for Helper II rankHelper 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

efowler's avatar
efowler
Icon for Helper II rankHelper II
5 years ago

I can't add my table because the data I am trying to create the running total on is a measure.  The MIS is a calculated column 

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi efowler ,

 

Please provide a sample pbix file, will make it much easier to craft a working measure for you

    • richbenmintz's avatar
      richbenmintz
      Icon for Resident Rockstar rankResident 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