Thank you so much, Mynda. I got this work now, Finally. Much appreciated for being so patient all the way. Regards, Aye
Many thanks, Sunny and Phil. I will try to know the system as well. Much appreciated for your kind help. Regards, Aye
Thanks, Mynda, Please see attached excel file and my expected result. Thank you. Regards, Aye
Hi Mynda, If expanding the rows by date as per fiscal period is not too simple, can I try a different one. I tried to add a column for fiscal pe...
Thanks, Mynda, That is just a sample result. I have 60 other facilities to be done in that way and it is rolling. I just want to know ho...
Hi Mynda, Sorry for confusion, I did not mean days, I mean dates. My FY Period from Stats_Act_FY2019 should be dates to match with AccomDate fro...
Hi Mynda, Can I have days of the month column instead of month start column. Can you please let me know where can I find the formula for days ...
Many thanks, Mynda. I will keep you posted. Regards, Aye
Hi Mynda, Sorry for being a pain. I now place my files on power query. Please see attached. I have to fix my dates from FY period in Stats...
Thanks, Mynda, I was in Power BI, edit query and trying to edit query. I suppose it is not the right way? Regards, Aye
Hi Mynda, Many thanks for your prompt reply. My data are from different sources. SB_SCC_Occupancy is from our main accounting software, imported...