LYTD expression after adding one more condition how to get return 288.743K ?

[admin11]

Hi All

Below expression working fine :-

Sales LYTD =

var _max = date(year(today())-1,month(today()),day(today()))

return

TOTALYTD(('SALES'[SALES_]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

Below expression no error but it return wrong value :-

Sales LYTD TI =

var _max = date(year(today())-1,month(today()),day(today()))

return

Calculate(TOTALYTD(('SALES'[SALES_]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

,filter(SALES,[SOURCE] = "TI"))

Below is my PBI file :-

https://www.dropbox.com/s/g49dls5dzfar6kv/PBT_V2021_392%20TI_SI_GL%20how%20to%20make%20LYTD%20add%20...

Paul Yeo

[AlB · Accepted solution]

Hi @admin11 

Sales LYTD TI V2 =
VAR _max =
    DATE ( YEAR ( TODAY () ) - 1, MONTH ( TODAY () ), DAY ( TODAY () ) )
RETURN
    CALCULATE (
        TOTALYTD (
             ( 'SALES'[SALES_] ),
            DATEADD ( 'Date'[Date], -1, YEAR ),
            'Date'[Date] <= _max
        ),
        Sales[SOURCE] = "TI"
    )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[admin11]

@AlB 

Thank you very much it work fine now.

Paul