Forum Discussion

EktaSoni_R's avatar
EktaSoni_R
Icon for Helper I rankHelper 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] )
        )
    )
EktaSoni_R's avatar
EktaSoni_R
Icon for Helper I rankHelper I
2 years ago

Fowmy  Yes actual current year - 2023 as current year.

Thanks 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
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] )
        )
    )
  • EktaSoni_R's avatar
    EktaSoni_R
    Icon for Helper I rankHelper I
    2 years ago

    Fowmy 

    Thank you very much , It is working ğŸ˜€