Forum Discussion

kormosb's avatar
kormosb
Helper III
5 years ago
Solved

Dynamic filter in a table

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 

 

  • kormosb , assuming CH% is a measure.

    A new measure like

     

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

1 Reply

  • kormosb , assuming CH% is a measure.

    A new measure like

     

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