Filtering a table's date field using expression

[nblf]

Hello Community,

I need some assistance with filtering a table's "Period" field, which contains dates in the format of YYYYMM, to show only periods that are earlier than the current date.

My plan was to create a button with an action to select variables in the field and use an expression such as Period < Date(today(), 'YYYYMM') to filter it. However, this method has not been successful.

I am hoping to find a solution. Thank you in advance for your help.

[BrunPierre]

Hi, perhaps use an expression to filter the table.

Sum({$<Period={"<=$(=Date(MonthStart(Today(), 0), 'YYYYMM'))"}>} YourMeasure)