Forum Discussion
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...
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)