Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community -
I have a table that contains Part #, Release Dates, Quantity and PO #. There can be multiple lines for each date and each part for each date (ex. Part 123 could have 5 lines on it for release date 1/1/2021). I am looking to calculate the SLOPE of the trend over a period of time. Shocking to me that Power BI does not have a DAX function for it yet.
Here is my current calculation I am using for SLOPE. It is appearing to work for some part numbers, but not for others (slope should be negative and it is showing positive for some).
Slope =
VAR _AvgX = CALCULATE(
AVERAGEX('Kyle TeslaReleases','Kyle TeslaReleases'[ReleaseDate_Mon]),ALLSELECTED('Kyle TeslaReleases'[ReleaseDate_Mon]))
VAR _AvgY = CALCULATE(
AVERAGEX('Kyle TeslaReleases','Kyle TeslaReleases'[Quantity]),ALLSELECTED('Kyle TeslaReleases') )
RETURN
DIVIDE(
SUMX('Kyle TeslaReleases',('Kyle TeslaReleases'[ReleaseDate_Mon]- _AvgX) * 'Kyle TeslaReleases'[Quantity]-_AvgY),
SUMX('Kyle TeslaReleases',('Kyle TeslaReleases'[ReleaseDate_Mon] - _AvgX) * ('Kyle TeslaReleases'[ReleaseDate_Mon]-_AvgX ) ) )
I cannot figure out the reason for the inconsistencies. I am not sure if it is due to parts have multiple lines for each release date, or if I am just missing something basic in my current measure.
Any help would be greatly appreciated.
Thank You
Ryan
hi @ryan_b_fiting - would you be able to share the pbix file or a sample file with some mocked up data so I can look at what is happening with the DAX.
Happy to help!
Proud to be a Super User!
@Sumanth_23 thanks for the response.
I have attached some sample data (with sensitive data removed/adjusted).
Let me know if this works for you.
Thanks for your help!
Ryan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |