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 efowler ,

 

Below you will find an example of a running total calculation, that should get you going in the right direction.

Cummulative R1000 = 
	Calcluate(
		SUM('table'[R1000]), 
			filter(
                                allselected('table'[MIS (Failure)]), 'table'[MIS (Failure)]<=max('table'[MIS (Failure)])
                     )
)

 

Hope that helps,

 

  • 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