Time-related calculation

[Fcoatis]

Hello,

I´m trying to build a metric which calculates sameperiodlastyear. I cant use the function because i have noncontiguos dates in my fact table. I got this to work out:

Fat Ano Ant:=CALCULATE (

        [Faturamento],
        FILTER ( ALL ( 'Calendar' ), 'Calendar'[Year] = YEAR ( TODAY () ) - 1 )
    )

It works if the field is collapsed. But when I try to expande the filter to months it gives only the result for the year:

How can aggregate by months?

Thanks in advance

[MFelix · Accepted solution]

Hi @Fcoatis,

Try something like this

Fat Ano Ant:=CALCULATE (
        [Faturamento],
        DATEADD(Calendar[Date],-1,YEAR)
    )

Regards,

MFelix

[Fcoatis]

That simple???

Thank you very much