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