Dynamic filter in a table

[kormosb]

Hi,

I would like to create a dynamic filter on my table, which always exludes the last month (so in this case August).

So, I don't want to use include the filter in the CH% measure, I would like to filter the last month in the table dynamically. I guess I would need a calculated column in the date table, which exlude the last month, right?

Thanks in advance,

Benjamin 

[amitchandak · Accepted solution]

@kormosb , assuming CH% is a measure.

A new measure like

calculate([CH%], filter(Table, Table[Date]<= eomonth(Today(),-1)))