Remove current Date's "month" from Script

[marcus_steggall]

Hi everyone, hope you're all well.

Hopefully a quick easy one, which I can't seem to get working.

Basically, I want a line of code in the script, that will ignore Today date's month.

So for example, we are 10 days into November and if we refresh a dashboard, I want this to show all data upto end of October.

No point, in showing data just for the first few days of November.

This way, the dashboard can automatically refresh each month.... safe in the knowledge, the data is only upto last month.

Any help, would be much appreciated.

Have a good day.

[oknotsen]

Add a where clause to your load script:

where someDate < MonthStart(today())

[sunny_talwar · Accepted solution]

With your sample data, try this:

LOAD Month,

  Period_Start_Date,

  Year

FROM

month.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Period_Start_Date < MonthStart(Today());

[marcus_steggall]

Thanks both, ahhh to the MonthStart function.

Much appreciated, just what i required.