Forum Discussion
Quarter Formulas
Hi I need to make an additional page in my report showing QUARTER, vs PREVIOUS QUARTER and vs LAST YEAR'S SAME QUARTER. Below is a sample data set and I added a new column that would compute the...
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!