Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
9 months ago

Help with Linear Trend line ?

Hi, Help me to get the trend line like below .   I have used LINESTX but I am getting the result below. I have attached my sample pbix file. https://github.com/suvechha/samp...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 months ago

ashmitp869 maybe try to change currentx value to this:

 

VAR CurrentX = RANKX(ALL('Date'[Year-Month Code], 'Date'[MonthYear]), CALCULATE( MAX('Date'[Year-Month Code])), , DESC)