ExcelToDAX
Active Member
- Joined
- Feb 9, 2023
- Messages
- 250
- Office Version
- 365
- Platform
- Windows
Is there a way to replace the TREND function in Excel to DAX? I want to forecast future trends. In Excel, I would put =TREND(C7:C30,D7:D30,D31) [assuming the dataset starts in B6.] I have tried creating my own Y = mx + b but I haven't been successful.
| Date | OST | Count |
| 01/1/2021 | $ 79,169,780 | 1 |
| 02/1/2021 | $ 79,231,903 | 2 |
| 03/1/2021 | $ 79,103,251 | 3 |
| 04/1/2021 | $ 78,989,302 | 4 |
| 05/1/2021 | $ 79,876,175 | 5 |
| 06/1/2021 | $ 80,829,112 | 6 |
| 07/1/2021 | $ 80,923,194 | 7 |
| 08/1/2021 | $ 81,616,249 | 8 |
| 09/1/2021 | $ 82,078,721 | 9 |
| 10/1/2021 | $ 82,866,655 | 10 |
| 11/1/2021 | $ 82,763,429 | 11 |
| 12/1/2021 | $ 82,226,724 | 12 |
| 01/1/2022 | $ 81,631,608 | 13 |
| 02/1/2022 | $ 81,310,098 | 14 |
| 03/1/2022 | $ 81,640,133 | 15 |
| 04/1/2022 | $ 81,509,193 | 16 |
| 05/1/2022 | $ 80,104,898 | 17 |
| 06/1/2022 | $ 81,084,133 | 18 |
| 07/1/2022 | $ 81,514,120 | 19 |
| 08/1/2022 | $ 81,502,443 | 20 |
| 09/1/2022 | $ 82,064,248 | 21 |
| 10/1/2022 | $ 84,051,577 | 22 |
| 11/1/2022 | $ 84,061,034 | 23 |
| 12/1/2022 | $ 85,485,643 | 24 |
| 1/1/2023 | 25 |
