Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello community,
Do someone know a DAX formular to create an manual linear forecast (Gradient I would like to define by my self).
The x-Achses is date Table (here the view in weeks)
The Graph should start at a defined date
Currently I have this try:
Somehow the datediff function is not working as expected
There are new functions since some weeks in DAX:
https://learn.microsoft.com/en-us/dax/linestx-function-dax
Proud to be a Super User!
Thank you for answer.
I am more searching for a easy implementation like:
y =mx +t (m= gradient, x = days from now, t=intercept [fix value])
Gradient & Intercept do not be calculated, I will define fix values.
I am trying this (but Date[date] as simple x value is not working:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 18 | |
| 14 | |
| 14 |