Forum Discussion
How do I compare compare dates and values?
It sounds like what you want is something along the lines of PARALLELPERIOD
There are also some techniques here that might help:
http://www.daxpatterns.com/time-patterns/
Not sure what you have tried thus far.
I suppose you want to compare januar 2014 to januar 2015. If so, you can use this DAX formula:
Prior Year Same Month Sales = CALCULATE(
SUM([Sales Amount]);
DATESMTD(SAMEPERIODLASTYEAR(Calendar[DateKey])))
Thanks for that. Using the forula below i just get a blank column. Why would this be?
YoY = CALCULATE(SUM(order_header_total[oht_foreign_net]),PARALLELPERIOD(order_header[oh_datetime],-1,YEAR))
I suppose you want to compare januar 2014 to januar 2015. If so, you can use this DAX formula:
Prior Year Same Month Sales = CALCULATE(
SUM([Sales Amount]);
DATESMTD(SAMEPERIODLASTYEAR(Calendar[DateKey])))
Thanks for this. A big help.
You are welcome. Hope it saves your time.