https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Existing-Item-or-new-one-count-items-in-the-last-week/m-p/3455979#M131738 <P>Hello all,</P><P>&nbsp;</P><P>Im trying to have a column that tells me if my item was already there the week before, or is a new one. Im not being able to do it, maybe someone here can helpme. Thanks!&nbsp;&nbsp;</P><P><img /></P><P>&nbsp;</P><P>In this case, I need that items 1 and 4 has in the Existing column "Y" bc are the one that the previous week were already in the table.</P><P>&nbsp;</P><P>Thanks!!</P> Mon, 02 Oct 2023 13:18:28 GMT anonnnn 2023-10-02T13:18:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Existing-Item-or-new-one-count-items-in-the-last-week/m-p/3455979#M131738 <P>Hello all,</P><P>&nbsp;</P><P>Im trying to have a column that tells me if my item was already there the week before, or is a new one. Im not being able to do it, maybe someone here can helpme. Thanks!&nbsp;&nbsp;</P><P><img /></P><P>&nbsp;</P><P>In this case, I need that items 1 and 4 has in the Existing column "Y" bc are the one that the previous week were already in the table.</P><P>&nbsp;</P><P>Thanks!!</P> Mon, 02 Oct 2023 13:18:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Existing-Item-or-new-one-count-items-in-the-last-week/m-p/3455979#M131738 anonnnn 2023-10-02T13:18:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Existing-Item-or-new-one-count-items-in-the-last-week/m-p/3456091#M131742 <P>Just in case anyone can use this in the future. I solved it concatenating two columns, one with the actual date and one with the prior date and use a lookup value.</P> Mon, 02 Oct 2023 14:20:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Existing-Item-or-new-one-count-items-in-the-last-week/m-p/3456091#M131742 anonnnn 2023-10-02T14:20:28Z