Need to find TOTALQTD for Previous year

[Anonymous]

Hi All,

I have calculated the below DAX measures which is working fine

• Revenue/Spend=Sum(Revenue)/Sum(Spend)
• Current QTD =TOTALQTD([Revenue/Spend],'DateDIM'[End of Week])
• Previous QTR QTD=Calculate([Revenue/Spend],PREVIOUSQUARTER('DateDIM'[End of Week]))

I need to find the TotalQTD for Previous Year same period. I have a date slicer which has week ending dates. 

DAX what I am using for it:

• PY QTD=Calculate([Revenue/Spend], PARALLELPERIOD(DATESQTD('DateDIM'[End of Week]),-1,YEAR)) .

But this PY QTD results are not coming correct. Kindly help.

Thanks in Advance

[amitchandak]

Please find an example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD('Date'[Date Filer]))
 Last year Qtr Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(ENDOFQUARTER(dateadd('Date'[Date Filer],-12,MONTH))))  // Use end of qtr only if required

PY QTD=Calculate([Revenue/Spend], (DATESQTD(dateadd('DateDIM'[End of Week],-1,YEAR)))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

@amitchandak 

Hey Amit, Thanks for your help.

No luck witk this DAX though.

PY QTD = Calculate([Revenue/Spend], (DATESQTD(dateadd('DateDIM'[End of Week],-1,YEAR))))

I found the solution. Below DAX is giving me correct results

PY QTD = Calculate([Revenue/Spend], SAMEPERIODLASTYEAR(DATESQTD('DateDIM'[End of Week])))

Thanks for sharing your Blog.

[VipulToshniwal · Accepted solution]

Hi,

Try using the SAMEPERIODLASTYEAR 

The Dax might look like this.

PY QTD=Calculate([Revenue/Spend], SAMEPERIODLASTYEAR('DateDIM'[End of Week]))

Please mark it as the solution if this works. 

[Anonymous]

@VipulToshniwal 

Hi Vipul,

Thanks for your quick response.

This works for me.

PY QTD = Calculate([Revenue/Spend], SAMEPERIODLASTYEAR(DATESQTD('DateDIM'[End of Week])))

Thanks!

[VipulToshniwal]

Hi @Anonymous ,

Would you kindly mark my DAX the solution? That will help others quickly get to it. Thank you.