How to display a projection on a graph based on last year's data?

[GeekAlfPro]

Hi,

i have a graph, wherin i display day by day bike's rental.

I'd like 

I'd like to display one-year forecasts (red lines) based on last year's data.

the measure i use to display the rental's is 

m_Nb_Vélo_actuellement_loues = 
CALCULATE(
COUNTX(
    FILTER(
        'Nombre total',
        'Nombre total'[Date Debut Loc] <=max('Date'[Date]) 
        
        &&(//ISBLANK('Nombre total'[Date retour])||
         'Nombre total'[Date réelle Retour Vélo]>= MAX('Date'[Date]))
        
        && 'Nombre total'[N° Mat interne] <> "A ATTRIBUER"
        ), 
        ('Nombre total'[N° Mat interne])
        
        
    ),
    CROSSFILTER('Nombre total'[Date Debut Loc],'Date'[Date],None)

How can i do ?

with a sameperiodlastyear ?

Thanks

[Anonymous]

Hi @GeekAlfPro ,

(1) You can create a line chart and then turn on Forecasting in the Analysis pane. Refer this, please note the limitations of this feature.

(2)Create a trendline using dax.

For more information, please refer:

How To Do Trend Analysis In Power BI Using DAX (enterprisedna.co)

Creating Forward Forecasts in Power BI Using DAX (enterprisedna.co)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.