Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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