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/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 .
4 Replies
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-Forum/ba-p/963216
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/1447523I 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.Any workarounds if anyone can help me with .
Your sample data is not usable. Please provide more realistic data.
