Forum Discussion
kormosb
5 years agoHelper III
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
- amitchandakSuper User
kormosb , assuming CH% is a measure.
A new measure like
calculate([CH%], filter(Table, Table[Date]<= eomonth(Today(),-1)))