How to convert YTD expression to LYTD ?

[admin11]

Hi All

Below YTD expression working fine , Return 759.60K :-

_YTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_REV] = "REV")

How to get LYTD expression ?

i Have try it return error :-

_LYTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESLYTD('Date'[Date],"12/31")), GL[1_REV] = "REV")

https://www.dropbox.com/s/7st0zke5hx206cy/PBT%20GL%20VER0023%20ask%20how%20to%20get%20LYTD%20REV%20w...

My PBI file above :-

Paul

[amitchandak · Accepted solution]

@admin11 , Try like

_LYTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD(dateadd('Date'[Date],-1,year),"12/31")), GL[1_REV] = "REV")

example

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

[admin11]

Hi Amit

Thank it work fine now

Paul