Peek orders from the last Year

[#1]

Hi,

I'm trying to peek orders from the last year but it doesn't work.

LOAD

     [Order ID],

  Max(Year([Order Date])) As MaxOrderYearByOrder

FROM [..\Qvd\FactOrders_6_Import.Qvd] (qvd)

Group By [Order ID];

Someone can explain me why ?

*It must be in the ETL process

Thank.

[Anonymous]

Above code gives you most recent order of evrey order id.

If you are pointing to last year then it has to be in where year(OrderDate)=(Year(today())-1)

[#3]

Hi Velagapudi,

This is not what I mean.

Thx.