But I would suggest to use Time Intelligence in such scenarios as your formulas are quite memory expensive and would not particularly suitable for large data sets. It is nesting the two iterator functions FILTER and SUMX.
Thanks & Regards,
Thanks & Regards, Bhavesh
Love the Self Service BI. Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
thanks a lot, helped me big time. Am only wondering whether I could amend the quarter columns using a business quarter. Sometimes, the company's fiscal year does not comprehend with the calendar year, the fiscal year in my case starts in October.
E.g Quarter 4 of calendar year 2016 = Quarter 1 of fiscal year 2017
How do I show the correct quarter in this case?
Secondly, lets assume I have a slicer for the month and pick up February, my column Previous month shows me an error and not the cost of January. How do I amend the formula to have it flexible, based on the slicer Fiscal Month?