Forum Discussion
Ethanhunt123
Helper IV
Helper IVLinestx when no data is available on x axis
I have created the DAX for linestx below -
Revenue trend =
VAR line =
LINESTX (
ALLSELECTED('Sales order line fact'[Order month]), -- This respects the slicer
[Total revenue trend],
'Sales order line fact'[Order month]
)
VAR slope = SELECTCOLUMNS(line, [Slope1])
VAR intercept = SELECTCOLUMNS(line, [Intercept])
VAR x = SELECTEDVALUE('Sales order line fact'[Order month])
VAR y = x * slope + intercept
RETURN y
My data has some gaps between them
May and June are not available
PBI is giving some weird results for those months. However, I need PBI to consider the total revenue trend as 0 and then calculate the revenue trend. Revenue trend for May and June should be around if total revenue is 0 for those months
| 57838.21 | ,51566.91 |
The months are date not text. 2023 Apr is 4/1/2023
3 Replies
- lbendlin
Super User
You are trying to do math with months? IE the integer representation for the first day of the month?
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Ethanhunt123The months are date not text. 2023 Apr is 4/1/2023
- lbendlin
That will create wonky results as the month start dates are not linear.
