YTD & LYTD is not working with Year Silicer

[jkhan]

i am using below dax for YTD & LYTD

TS_YTD = TOTALYTD( SUM(PBI_FACT_UCAS_PO[ORDER_AMOUNT_SAR]),'date'[Date])

TS_LYTD = VAR DataMaxDate = CALCULATE ( MAX ( 'PBI_FACT_UCAS_PO'[ORDER_DATE] ), ALL ( PBI_FACT_UCAS_PO ) )

RETURN

CALCULATE ( [TS_YTD], SAMEPERIODLASTYEAR ( DATESBETWEEN ( 'date'[Date], BLANK (), DataMaxDate ) ) )

When I added Year Silicer and Selecting Particular Year, LYTD  Values are not getting changed

and also YTD is showing Sales for complete Year not upto JUNE month.

[jkhan]

Please do help me to fix this issue. 

---

[v-piga-msft]

Hi @jkhan ,

What about this measure below?

LYTD = CALCULATE([YTD],DATEADD('Date'[Date],-1,YEAR))

Here is my test output.

If you still need help, please share your data smaple and your desired output so that we could help further on it.

Best  Regards,

Cherry

[jkhan]

I have modified my LTYD DAX to below

TS_YTD = TOTALYTD( SUM(PBI_FACT_UCAS_PO[ORDER_AMOUNT_SAR]),'date'[Date])

TS_LYTD = CALCULATE([TS_YTD],DATEADD('Date'[Date],-1,YEAR))

For 2019 YTD is working fine taking Date from JAN-2019 to JUN-2019

But LYTD is taking complete 2018 Year i.e. JAN-2018 to JUN-2018

For 2018 YTD is taking complete 2018 Year JAN-2018 to JUN-2018

And LYTD is taking complete 2017 Year i.e. JAN-2017 to JUN-2017

I want YTD  and LYTD to work from JAN to JUN for any year selected in Slicer

If you have DAX please do share with me, I am trying to achive above result from long time but no success.

Best Regards

Jamsher 

[jkhan]

Thanks for Reply, I will test now and will share output.