Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to get previous month sales using dax

I have multiple years and months data in this how to get recent previous month total sales .How system identify previous month on multiple years .

My requirment is once open dashboard I want Previous month total sales in card visualization . I will not select perticular date , automatically sytem will undersatand what is current month and current year based on it will give current previous month total sales .

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks it's useful based on that implemented getting correct result . 

  • Reddy5833's avatar
    Reddy5833
    Icon for Helper II rankHelper II
    3 years ago
    Previous Month Sales =
    Var
    MonthNumber = IF( MONTH(TODAY())-1 = 0, 12,MONTH(TODAY())-1 )
    Var
    YearNumber = IF(MonthNumber = 12, YEAR(TODAY()) -1, YEAR(TODAY()))

    Return

    IF(
    ISBLANK(CALCULATE(Sum(Table[sales]), FILTER (ALL('Date'), 'Date'[cal_year] = YearNumber && 'Date'[cal_month] = MonthNumber)))
    ,0
    ,CALCULATE(Sum(Table[sales]), FILTER (ALL('Date'),'Date'[cal_year] = YearNumber && 'Date'[cal_month] = MonthNumber))
    )