10 Replies Latest reply: Dec 13, 2016 7:11 AM by Nitin Gaikwad RSS

    How to Check if value exists with date

    Dipesh Vadgama

      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);