Forum Discussion

EktaSoni_R's avatar
EktaSoni_R
Helper I
2 years ago
Solved

Cummulative Sales calculation only for previous year.

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 ...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    2 years ago

    EktaSoni_R 

    Please try this:

    YTD LY = 
    IF( YEAR( MAX( 'Date'[Date] ) ) = YEAR( TODAY()),
    
        CALCULATE(
            CALCULATE(
                [Sales Amount],
                DATESYTD( 'Date'[Date] )   
            ),
            SAMEPERIODLASTYEAR( 'Date'[Date] )
        )
    )
philouduv's avatar
philouduv
Resolver III
2 years ago

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

Amountdate

104/12/2023
226/08/2023
318/05/2023
407/02/2023
530/10/2022
622/07/2022
713/04/2022
803/01/2022
925/09/2021
1017/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's avatar
EktaSoni_R
Helper I
2 years ago

philouduv ,

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