Forum Discussion
Brendy_P
Helper I
Helper ILY Fiscal Calculation
Hi All, Hopefully I can explain my dilemma adequately for you to help me. Thank you in advance. I am looking to calculate last years total from my Calendar table which is based on my company's fisc...
Brendy_P , If you have Oct-2025 or onward
New Calendar
Do these entries
Formula
YTD FY = CALCULATE([Net], DATESYTD('FY'))
amitchandak
Super User
Super UserBrendy_P , If you have Oct-2025 or onward
New Calendar
Do these entries
Formula
YTD FY = CALCULATE([Net], DATESYTD('FY'))
Brendy_PHelper I
Helper IHi
amitchandak Praful_Potphode MohdZaid_
I appreciate and would like to thank you all for your help. I have since found out that my company uses a 4-4-5 week calendar. Having said that amitchandak suggestion probably answers my qustion. Thank you all