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]), SAMEPERIODLASTYEAR(Table[date]), my issue is the Executives insisted on using the company's Quarter as a filter and DO NOT Wish to see the DATES
I dont know how to add image file to this 'new message forum'. What happen to the browse button?
Can you advise I to upload image.. It is asking for Source & Image Description
Mal
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
2 Replies
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