VALUES function with DATEADD

[patri0t82]

Hello, can someone please help me adjust this DAX measure? Currently it's collecting all hours within the selected date range, I'd like to use DATEADD to select minus one month

YTD Hours Count =

CALCULATE (

SUM ( 'Hours - Tabular'[Value] ),

USERELATIONSHIP ( 'Recordable'[Operating Area], 'Hours - Tabular'[Operating Area] ),

VALUES(CalendarTable[Date])

)

I tried 

YTD Hours Count =

CALCULATE (

SUM ( 'Hours - Tabular'[Value] ),

USERELATIONSHIP ( 'Recordable'[Operating Area], 'Hours - Tabular'[Operating Area] ),

VALUES(DATEADD(CalendarTable[Date], -1, MONTH))

)

but it didn't like that.

Thank you!

[patri0t82 · Accepted solution]

This works!

YTD Hours Count (Last Month) =

CALCULATE(

TOTALYTD (

SUM ( 'Hours - Tabular'[Value] ),

DATEADD( 'CalendarTable'[Date], -1, MONTH)),

USERELATIONSHIP ( 'Recordable'[Operating Area], 'Hours - Tabular'[Operating Area] )

) + 0

[patri0t82]

Turns out my solution isn't quite working properly. Can anyone tell me a better way of writing it?

[patri0t82]

I think I figured it out:

YTD Hours Count (Last Month) =

CALCULATE (

SUM ( 'Hours - Tabular'[Value] ),

USERELATIONSHIP ( 'Recordable'[Operating Area], 'Hours - Tabular'[Operating Area] ),

VALUES(CalendarTable[Date]),

DATEADD(CalendarTable[Date],-1,MONTH)

)