Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum({<Date = {"$(='>=' & Date(MonthStart(Today(), 1), 'DateFieldFormatHere'))"}>}Measure)
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"
This didn't work?
Sum({<[Target Date] = {"$(='>=' & Date(MonthStart(Today(), 1), 'MMM-YY'))"}>}Measure)