Cummulative Sales calculation only for previous year.

[EktaSoni_R]

Hello, 
I have tried to calculated only previous year cumulative sales, But unable to achive, i have tried n number of formulas but i am unable to get the output. Below dax is giving me till todays month data , i want restrict only for the last year. Any lead will be much appreciated.

LastYearAccumulativeRevenue =
CALCULATE(
SUM([amount]),
YEAR('Date'[Date]) = YEAR(TODAY())-1,
'Date'[Date]<= MAX('Date'[Date])
)

[Fowmy]

@EktaSoni_R 

Folow this pattern:

YTD LY = 
CALCULATE(
    CALCULATE(
        [Sales Amount],
        DATESYTD( 'Date'[Date] )   
    ),
    SAMEPERIODLASTYEAR( 'Date'[Date] )
)

[EktaSoni_R]

@Fowmy 
Above Dax is giving correct output while testing using the table view with date slicer, but the problem is when same i am using in Bar chart without any slicer, it is giving the all previous year data which is present in date table.

 My current requirement is there wont be any slicer for date, chart shows only for previous year cummulative value.

[Fowmy]

@EktaSoni_R 

I am not sure how you have used the measure on the bar chart. However, the basic idea is that you need to have a date in the x-axis it could be month, qtr or year, in the Y-axis add the this measure. 

[EktaSoni_R]

@Fowmy Thanks for the relpy, I have used the Mon-Year in X asix , you can see in the chart that it is showing for all the previous year, I just want to stick only to the last year.

[Fowmy]

@EktaSoni_R 

In that case I need to now how you want the current year to be considered if you dont select any date from the date table. IS it fine take actual current year like 2023

[EktaSoni_R]

@Fowmy  Yes actual current year - 2023 as current year.

Thanks 

[Fowmy · Accepted solution]

@EktaSoni_R 

Please try this:

YTD LY = 
    IF( YEAR( MAX( 'Date'[Date] ) ) = YEAR( TODAY()),
    
        CALCULATE(
            CALCULATE(
                [Sales Amount],
                DATESYTD( 'Date'[Date] )   
            ),
            SAMEPERIODLASTYEAR( 'Date'[Date] )
        )
    )

[EktaSoni_R]

@Fowmy 

Thank you very much , It is working 😀

[philouduv]

Hello @EktaSoni_R,
I tried a little calculated column in a fake table that had 2 column, amount and date. 

Amountdate

1	04/12/2023
2	26/08/2023
3	18/05/2023
4	07/02/2023
5	30/10/2022
6	22/07/2022
7	13/04/2022
8	03/01/2022
9	25/09/2021
10	17/06/2021

Hope it helps, if not you would need to give further details.
Formula: 

cumulative_sum_previous_year = CALCULATE(SUM(Table9[Amount]),

 Filter(Table9,

 Table9[date].[Year] < MAX(Table9[date].[Year])

 &&

 Table9[date].[Year] > MAX(Table9[date].[Year]) - 2

 ))

Best regards,

[EktaSoni_R]

@philouduv ,

Thanks for the reply, but this solution is not working for me.