Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Gareth_Hunt
Helper II
Helper II

trend line gradient value

Hi Guys can you help 

 

I found this post

https://community.powerbi.com/t5/Desktop/Trend-line-values/m-p/1646737#M660327

 

that provies a measure that approximates to a trend line ,but What iwant to knwo is hte value of the "slope / gradient" of the linear recession - I want apply to sales of a product to determine growth/decline rate

 

please help!!!!

 

with best regards

 

gareth

 

1 REPLY 1
v-deddai1-msft
Community Support
Community Support

Hi @Gareth_Hunt ,

 

Are you try to calculating sales change percentage over time? It's better that you can create a calendar table in your data model, and use the previousmonth function(aggregation of month). For more details, please refer to https://www.mssqltips.com/sqlservertip/6424/calculate-percentage-growth-over-time-with-power-bi/

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.