Exclude current week

[stekol61]

Hi!

I'm loading data and converts 'Date' to 'Week' as below .

How can I always exclude the current week when data is loaded?

LOAD

Year(event_start_time)&'-'& Week (event_start_time)as Week,

[sunny_talwar · Accepted solution]

May be this

Where WeekStart(event_start_time) <= WeekStart(Today());

[petter]

You could filter by a

LOAD

    ....

    .....

FROM

   ....

WHERE

  event_start_time < WeekStart(Today(1));