Forum Discussion
Quarter Formulas
Hi v-frfei-msft !
I tried to input your formulas in my file....I almost got it.
I dont' know what I'm doing wrong for the "Previous Quarter" , though. Do you have any idea?
Hi newgirl ,
To create a CALENDAR table should help. Please have a try. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi v-frfei-msft !
Here is the link for the file -
https://drive.google.com/file/d/1TW-7qdHcoKikw2TCCq4mjjGy87s7fQkb/view?usp=sharing
There's no confidential info inside since I just made up the raw data for sample purposes. Kindly refer to Page 2.
My expected result for "Q_PQ" (it means QTD_Previous Quarter) is 86 but instead, my file shows 212.
Thank you!