Forum Discussion
Comparing Values between 2 periods without using "dates"
Hi PBI, The Fiscal period of my company starts in November. So the Fiscal Qtr for "Qtr1 2013" = Nov2012 + Dec2012 +Jan2013. Whilst I can compute Sales Last Year ( = Sumx(Table,[Total Sales]), SAMEPER...
Hi Anonymous,
Please try to create the measure to calculate the sales last year below:
Sales Last Year = CALCULATE( SUM(data[Sales]), FILTER(ALL(data),'data'[CorpYr]=MAX('data'[CorpYr])-1 &&'data'[CorpQtr]=MAX('data'[CorpQtr])))
Best Regards,
Qiuyun Yu
worked out how to load - I forgot to sign in