How to convert YTD expression to LYTD ?

[admin11]

Hi All

@dvl_ctaul 

Give me below very powerful expression :-

Sales YTD flex = CALCULATE ( [SALES_],DATESYTD('DATE'[Date])

)

I want to convert the above expression to LYTD , i try :-

Sales LYTD flex = CALCULATE ( [SALES_],DATESLYTD('DATE'[Date])

)

it does not work.

Can some one advise me .

Paul

[AlexisOlson · Accepted solution]

There are a few functions you can try for this: SAMEPERIODLASTYEAR, PARALLELPERIOD, DATEADD

For example,

CALCULATE (
     [SALES_],
     DATEADD ( DATESYTD ( 'DATE'[Date] ), -1, YEAR )
)

See here for more discussion:
https://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-question

https://community.powerbi.com/t5/Desktop/DateAdd-vs-ParallelPeriod-vs-SamePeriodLastYea/m-p/689019

https://community.powerbi.com/t5/Desktop/SAMEPERIODLASTYEAR-DATESYTD-different-from-DATESYTD/m-p/594...

[VahidDM]

 @admin11 Paul,

Try this:

Sales LYTD flex = CALCULATE ([Sales YTD flex],SAMEPERIODLASTYEAR('DATE'[Date])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/