same period 3 years ago for a fiscal year

[Anonymous]

I thought this would be easy....

I have 2 fiscal years of data:

Mar 1, 2015 - Feb 29, 2016 = F2016

Mar 1, 2018 - Feb 28, 2019 = F2019

All I'm trying to do is calculate the % increase between these two years.  (for sales, GP$, vehicle count, etc...)

I've tried parallelperiod but it just gives me same values for F2016, and nothing for F2019?!

Prior sales = CALCULATE([Sales $], PARALLELPERIOD('Date'[Date], -3, YEAR))

PLEASE HELP!!!

[jdbuchanan71]

@Anonymous 

Try it with DATEADD instead.

Prior Sales =
CALCULATE ( [Sales $], DATEADD ( 'Date'[Date], -3, YEAR ) )

PARALLELPERIOD was giving me some odd results in my test file (attached) but DATEADD worked fine.

[Anonymous]

This gives the same result as PARALLELPERIOD.

[jdbuchanan71]

@Anonymous can you share your .pbix file?

[Anonymous]

Yes, can you walk me through how to do that?

I can't share my original file but I made a mock-up on that I can share. Both formulas come up with blank values so I figure if that issue gets solved I can try to apply it to my actual model.

[jdbuchanan71]

The easiest way is to put it in OneDrive or DropBox then post the link here.

[Anonymous]

https://kaltire-my.sharepoint.com/:f:/r/personal/jacquie_rintoul_kaltire_com/Documents/Power%20BI%20...

Like that?

Thank you for your help, I REALLY appreciate your time!