Hi Riny, Yes you are right, for the previous year, you would record grouped data in the same columns M1 to M12 but with a FiscalYear of "2023/24". ...
Thanks Riny for your reply. The sample data is the depiction of real data. There are no dates, it just when we recieve the data for new month ...
Well, my data is huge, there are two years of data pulled by Power query (way to many rows). Not sure if Power query can do this kind of calculation a...
Hi Riny, Please see the attached Sample file. Please note couple of things: In my Original file, the data is pulled through Power query ...
Hi Riny, Thanks for your reply. Apology, I forgot to mention, this calculation I would like to do in Power Pivot using DAX. So, when I create...
Hi, Sorry for the confusion. I have added few more rows into the "data tab". Also explained it more better in the tab "Result I want". I hope it...
Hi, I have connected to the file using a fresh connection and without applying any transformations. Even when you connect to a folder, it shows ...
Hi Velouria, Thank you very much for your help and for providing the solution. it's amazing to see how Expert minds work and how they come up wi...
Thank you so much, Riny. It is working now. I really appreciate the time and effort you have put into resolving my queries.