3M trend calculation using linear regression method

[RB-0613]

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/03/2017      50

01/04/2017      25

.

.

.

01/06/2023.     32

I need to create 3 months trend , 6months trend based on above sample data . 
I need to see forecasted value of sales starting from 01/07/2023 using linear regression technique so I get a straight line for trends calculation . 

[RB-0613]

Any workarounds if anyone can help me with .

[lbendlin]

Your sample data is not usable.  Please provide more realistic data.

[RB-0613]

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.

[lbendlin]

You are making conflicting statements on what you are trying to achieve. Did you try to use the built-in trending line or forecast line?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...