Excellent video David. The topic of the fiscal year in companies is very interesting. Congratulations on the MVP award, absolutely deserved, my friend. Thank you so much!!!
@Abioladavid01 Жыл бұрын
Thanks for your comment friend
@abdallahdataguy Жыл бұрын
Great video Abiola. I like using FYYearQuarter like "FY2012Q4" or just 2012Q4 which automatically sorts in pivot table
@anisa5656-l1z5 ай бұрын
If it is assumed fiscal year starts from July and I used the function as . But calendar quarter '1', the result comes '-1' and calendar 'quarter 2' is showing '0'. Could you tell me, where is my error in the function?
@MahmoudAnass-c9n Жыл бұрын
How about if the Fiscal year starts from July till June? what should be right formula? for both FY Quarter and FY
@Abioladavid01 Жыл бұрын
Then you have to replace the 4 with 6 in the Fiscal Quarter calculated column