Forum Discussion

Fyouri's avatar
Fyouri
Frequent Visitor
10 years ago
Solved

Problem with running total

I have a list where i keep track of the total number of hours worked in a company per month. I need to get a sum of the last 12 months  on each row. This is what i would want:   Date              T...
Need Help
  • sdjensen's avatar
    sdjensen
    10 years ago

    You could try something like this:

     

    CALCULATE(
	SUM( 'Table'[Total Hours] ),
	DATESBETWEEN(
		'DateTable'[Date],
		NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'DateTable'[Date]) ) ),
		LASTDATE ( 'DateTable'[Date] )
	)
)
sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Do you have a seperate table with all the dates from the first date in your data to the last and made a relationship between these 2 tables?

Fyouri's avatar
Fyouri
Frequent Visitor
10 years ago

Thanks Sdjensen,

 

I forgot to make a connection between the 2 tables. It works now.