How to Check if value exists with date

[DipeshVadgama]

Dear All,

I am trying to find if Current week "Number" exist in pervious week "Number".

I try to use Exists & match but no use.

Dat:

LOAD [Date],

[Number],

    Match(if([Date]>Today()-6,[Number]),if([Date]<=Today()-6,[Number])) as "Repeated"

FROM [lib://Dat.xlsx]

(ooxml, embedded labels, table is Sheet2);

[nitin_01]

Your right Vineeth, I missed it.

Regards,

Nitin