Getting 2 years back total !

[Jitmondo]

Hi All,

something simple I think but can't get it to work.

I have a graph where I am showing last years won deals :

Last Year Closed Won = TOTALYTD([Closed Won Weighted Pipeline],SAMEPERIODLASTYEAR(Dates[Date]))

this works fine and is shown as a line.

my current measurs and visuals are dynamic and change with year selector slicer so this new measure would need to be too.

Is there a way to write a measure that shows the year before that ?

[v-jayw-msft · Accepted solution]

Hi @Jitmondo ,

You could try use edate() function. Please check this measure.

measure =

var _date =selectedvalue('date'[date])

return
calculate(sum([value]),filter(allselected('table'),'table'[date]>=date(year(_date)-2,1,1)&&'table'[date]<=edate(_date,-24)))

Best Regards,

Jay

[Jitmondo]

thanks for replying, my last year (sameperiodlast year) works fine. I am trying to see if there is a way to alter this measure or a new measure to show the year before last...

[Anonymous]

Please check PARALELLPERIOD function then, it should work 🙂 

PARALLELPERIOD function (DAX) - DAX | Microsoft Docs

Your interval should be -2 for example:

CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PARALLELPERIOD(DateTime[DateKey],-2,year)) 

 

[Anonymous]

Good morning @Jitmondo 

Please check this previus answer and see if they work for you: 

Solved: TOTALYTD with SAMEPERIODLASTYEAR not working as ex... - Microsoft Power BI Community

If you have a slicer with the dates they should work.

Regards!