Not getting the YTD of previous year using measures

[Anonymous]

my previous year measure is showing wrong value. Can anyone help with this ?

cytd = TOTALYTD(SUM(FinalTable[Value]),FinalTable[Date],FinalTable[Date]<=TODAY(),"12/31")

pytd =

CALCULATE ( [cytd], SAMEPERIODLASTYEAR ( FinalTable[Date]), FILTER ( ALL ( FinalTable ), FinalTable[Date] <= DATE(YEAR(TODAY()) -1 , [Maximum], 1)))

Maximum =CALCULATE ( MAX( FinalTable[MonthNumber]), FILTER ( ALLSELECTED ( FinalTable), FinalTable[Value] <> BLANK ()

&& FinalTable[YearNumber] = [year selected] ))

Note: I am not using Date table as I need the filter slicers as shown in below screenshot.

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you to use date function to define filter range to calculate, it is hard to custom and accuracy control the nested calculation of time intelligence functions.

Time Intelligence "The Hard Way" (TITHW)  

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous ,

First of all, Thanks for the ref link which is helping me. But when I am trying it. I get the below visual error. Can you help me with that ?
Is there any other formula for LYTD ?
Checking on 2020 is fine. But when checking on other years give me error.

 I have the same measures 

TI_TotalYTD = TOTALYTD(SUM(FinalTable[Value]), DateTable[Date])

TI_TotalLYTD = CALCULATE([TI_TotalYTD],SAMEPERIODLASTYEAR(DateTable[Date]))

Relations in model is as follows
Relation for FinalTable and DateTable is Many to one with Both Corss filtering.

Let me know where is my issue.

[Anonymous]

Thanks @Anonymous ,

Your suggestion helped me. For the above issue, i have changed the relation of cross filter for DateTable and FinalTable Date column to Single.

Happy to learn Power bi.

[Anonymous]

Hi @v-huizhn-msft 
I have seen similar post in the below link.
https://community.powerbi.com/t5/Desktop/How-to-display-sales-YTD-and-sales-last-YTD-over-years/td-p...

Mine is similar issue but On check of the year number in slicer i need to calculate YTD and also Previous year YTD.
Your suggestions will be helpfull. 

I need this quick so I have tagged you. Anyone else who can help me with this will be great. Thanks in Advance.