Filter the records till last month in DAX - New column
Hello everyone, I am creating a new column with the below DAX query which is working fine. Running Total = CALCULATE( SUM('Actuals from Ecosys'[CoCo Costs.Incur_Cost_TD]), FILTER( 'Actuals from Ecosys', 'Actuals from Ecosys'[Package]=EARLIER('Actuals from Ecosys'[Package]) && 'Actuals from Ecosys'[Month] <= EARLIER('Actuals from Ecosys'[Month]) ) ) I don't want the cumulative formula to be applied for upcoming months. I tried restricting by adding one more line to the last && 'Actuals from Ecosys'[Month] < TODAY() which did not give the desired results. Kindly share your thoughts. Thanks, Karthik
