Last 3 months data

[#1]

Hi Experts,

I have 3 Years of data ,but i want to load  last 3 months data excluding current month.

here i have date field.

For ex this is April month  but i need jan, feb, march data  if go to next month it has to  load feb,march,april like that .

[Gysbert_Wassenaar]

You can use a WHERE clause to filter the data you load. Something like this:

LOAD

     Date,

     ...some other fields...

FROM

     ...data source...

WHERE

     Date >= num(MonthStart(Today(),-3) and Date < num(MonthStart(Today())

     ;