Adding 2 different trend lines

[heiko_schmidt]

Hello, i use a function to show a trend line :

linest_b (

          total aggr(

              Sum(Expression1),

               [Month]

           ),

           [Month]

      )

+

  Month *           

      linest_m (

          total aggr(

              Sum(Expression1),

               [Month]

           ),

           [Month]

      )

This one calculates the trend line for all available months.

Is it possible to show a second trend line in the same diagramm that only shows the trend for the past 6 months and a third one that shows the trend line for past 3 months to 3 months in advance.

Best regards

Heiko

[shraddha_g]

It is possible..

Add 3 different measures in line chart

[heiko_schmidt]

Hello, Shraddha, thank you for your response.

Maybe the question was a little bit confusing. I know that it is possible.

I just don´t know how to set the right time interval.

Best regards

[jonathandienst]

Its hard to give detailed help without more information. Are you using a master calendar? In general, you would add set expression filters to the linest() function and/or the sum() functions inside the Aggr() expression.

I suggest that you upload a small sample file that contains enough data to get more detailed help.

[heiko_schmidt]

Hello Jonathan, yes I am using a master calendar.

Here is the sample file.

I want to show one trend line over all available months ( this already works) and another trend line for the last 6 months dynamically.