Forum Discussion
Cumulative Total with 2 parameter columns
Asking for your kind help fellow Power BI Users. Thank you in advance for those who would take time to help 🙂 Sample File: Power BI Sample I am trying to have cumulative total per month wit...
amitchandak
Super User
Super UserAnonymous , You can use datesmtd for that
example
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
Or have a month Day columns and month Rank
Month Rank = RANKX(all('Date'),'Date'[Month Start date],,ASC,Dense)
Month Day = day([date])
measures
MTD = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Month Rank]=max('Date'[Month Rank]) && [Month Day] <=max([Month Day])))
LMTD = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Month Rank]=max('Date'[Month Rank])-1 && [Month Day] <=max([Month Day])))