Comparing Values between 2 periods without using "dates"

[Anonymous]

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

[v-qiuyu-msft · Accepted solution]

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

[Anonymous]

worked out how to load - I forgot to sign in