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] )
        )
    )
Fowmy's avatar
Fowmy
Super User
2 years ago

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's avatar
EktaSoni_R
Helper I
2 years ago

Fowmy  Yes actual current year - 2023 as current year.

Thanks 

  • Fowmy's avatar
    Fowmy
    Super 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
      Helper I
      2 years ago

      Fowmy 

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