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 
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's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

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

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

        Fowmy  Yes actual current year - 2023 as current year.

        Thanks