Forum Discussion
sameperiodlast year
It is urgent please help I have data till 1st Aug 2023 in an Excel sheet. The remaining sheet is blank below the 1st AUg. Slicer Selection:- 31st July 2023 to 1st August 2023 Date SUM Last Ye...
| DATE | VALUE |
| Sun 31-Jul-22 | 2 |
| Mon 01-Aug-22 | 3 |
| Tue 02-Aug-22 | 4 |
| Wed 03-Aug-22 | 5 |
| Thu 04-Aug-22 | 6 |
| Fri 05-Aug-22 | 7 |
| Sat 06-Aug-22 | 8 |
| Sun 07-Aug-22 | 9 |
| Mon 08-Aug-22 | 2 |
| Tue 09-Aug-22 | 3 |
| Wed 10-Aug-22 | 4 |
| Thu 11-Aug-22 | 5 |
| Fri 12-Aug-22 | 6 |
| Sat 13-Aug-22 | 7 |
| Sun 14-Aug-22 | 8 |
| Mon 15-Aug-22 | 9 |
| Tue 16-Aug-22 | 2 |
| Wed 17-Aug-22 | 3 |
| Thu 18-Aug-22 | 4 |
| Fri 19-Aug-22 | 5 |
| Sat 20-Aug-22 | 6 |
| Sun 21-Aug-22 | 7 |
| Mon 22-Aug-22 | 8 |
| Tue 23-Aug-22 | 9 |
| Wed 24-Aug-22 | 2 |
| Thu 25-Aug-22 | 3 |
| Fri 26-Aug-22 | 4 |
| Sat 27-Aug-22 | 5 |
| Sun 28-Aug-22 | 6 |
| Mon 29-Aug-22 | 7 |
| Tue 30-Aug-22 | 8 |
| Wed 31-Aug-22 | 8 |
| Mon 31-Jul-23 | 9 |
| Tue 01-Aug-23 | 5 |
| Date selected in slicer is 31st July 2023 to 1 August 2023 | ||
| Expected | Output (31st August 2023 to 1 August 2023) | Output Sameperiod last year function output |
| Average | 7 | 2.5 |
| Sum | 14 | 5 |
| Ourput | ||
| Average | 7 | 5.46 |
| Sum | 14 | 175 |
see attached
