Forum Discussion
3M trend calculation using linear regression method
Hi , I have a tableA that has date and sales value column. Date column has data from 03/2027 till 06/2023 I have also created a date table . Sample TableA data : Date Value 01/...
I have attached sample data below.
| Date | Value |
| 01-03-2022 | 82 |
| 01-04-2022 | 53 |
| 01-05-2022 | 75 |
| 01-06-2022 | 64 |
| 01-07-2022 | 88 |
| 01-08-2022 | 75 |
| 01-09-2022 | 50 |
| 01-10-2022 | 81 |
| 01-11-2022 | 63 |
| 01-12-2022 | 43 |
| 01-01-2023 | 94 |
| 01-02-2023 | 68 |
| 01-03-2023 | 73 |
Below is the image of expected results.