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

efowler's avatar
efowler
Helper II
5 years ago

Hi, thanks..    R1000 is a measure.  Does that make a difference?   I can not find the 'table'[R1000], I believe that is because it is a measure?

richbenmintz's avatar
richbenmintz
Resident Rockstar
5 years ago

Hi efowler ,

 

'table' is a place holder as i do not know the name of your table, for the measure name please leave out the table name

  • efowler's avatar
    efowler
    Helper 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
      Resident Rockstar
      5 years ago

      Hi efowler ,

       

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