topic Is there a Dax or Var formula to sum across rows for 3,6,9 months? in DAX Commands and Tips

Is there a Dax or Var formula to sum across rows for 3,6,9 months?

Anonymous — Fri, 19 Jan 2024 09:40:34 GMT

Hi All,

I am trying to find a solution to add columns that sum across rows for customers as in the example below:

Re: Is there a Dax or Var formula to sum across rows for 3,6,9 months?

saurabhtd — Fri, 19 Jan 2024 10:37:46 GMT

Anonymous You can try these formulas for creating calculated column.

Last 3 Months = VAR CurrentMonth = MAX(Table[Month]) RETURN CALCULATE( SUM(Table[Revenue]), FILTER( Table, Table[Customer] = EARLIER(Table[Customer]) && Table[Month] >= CurrentMonth - 2 ) )

Last 6 Months = VAR CurrentMonth = MAX(Table[Month]) RETURN CALCULATE( SUM(Table[Revenue]), FILTER( Table, Table[Customer] = EARLIER(Table[Customer]) && Table[Month] >= CurrentMonth - 5 ) )

Last 9 Months = VAR CurrentMonth = MAX(Table[Month]) RETURN CALCULATE( SUM(Table[Revenue]), FILTER( Table, Table[Customer] = EARLIER(Table[Customer]) && Table[Month] >= CurrentMonth - 8 ) )

Re: Is there a Dax or Var formula to sum across rows for 3,6,9 months?

Anonymous — Sun, 21 Jan 2024 16:00:04 GMT

saurabhtd what format should the folling be? 'Table'[Month]

Re: Is there a Dax or Var formula to sum across rows for 3,6,9 months?

Anonymous — Thu, 25 Jan 2024 22:46:14 GMT

Is it possible to add a if statement here as well? So if 0 revenue, then "Lost Customer"