Straight table, only show field equal or greater than this month?

[kfahri342]

Hi All,

I have a list of data on a Straight Table, which I need to limit to only show when the date of that item, is equal too or greater than today's month. Is there an expression for this?

Many Thanks

Kozan

[sunny_talwar]

May be this

Sum({<Date = {"$(='>=' & Date(MonthStart(Today(), 1), 'DateFieldFormatHere'))"}>}Measure)

[kfahri342]

Thanks for the reply.

Unfortunately, it didn't work - it just kept saying ERROR IN EXPRESSION.

If it help, the column I am trying to filter is called "Target Date" and the format is "MMM-YY"

[sunny_talwar]

This didn't work?

Sum({<[Target Date] = {"$(='>=' & Date(MonthStart(Today(), 1), 'MMM-YY'))"}>}Measure)