DAX function creating measure calculate last month/last year value with filter

[Anonymous]

hi, I am using DAX create the measure to get the LY or LM data how every, seems not working any suggestion. 

1. create a measure 

then create another measure base on this having filter

2. create the last month value by using

sum mactual LM = CALCULATE([sum value], FILTER(kicksall, kicksall[acc_disc]="MAN"), DATEADD(Calendar[Date],-1, MONTH)

(this not function, saying need continues value of add date, ) then I change to  

sum mactual LM = CALCULATE([sum value], FILTER(kicksall, kicksall[acc_disc]="MAN"), DATEADD(kicksall[fdate],-1, MONTH)

I have 2 tables in relation here. 'kicksall' [fdate] and 'calendar'[date]

the function seems work (no error )but no output if i use table to check (but have total value???)

any suggestion 1. why i can not use Calendar[Date]? 2. why there is no month output?

the data I have is monthly data so fdate is not continues, i add 01 to each month, so fdate only have 1 day per month

thank you!

[Greg_Deckler]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...