Filter the records till last month in DAX - New column

[Anonymous]

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

[Anonymous · Accepted solution]

Thanks for your response @Jihwan_Kim . I somehow resolved it in a different way, I will get back to you if the solution wont work properly.

[Jihwan_Kim]

Hi, @Anonymous 

Do you have a date column inside the same table?

If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate formula for creating a new column.

Thanks.