Count of Unique Values Sold Each Day Based on Sales to Date + Running Total
I am badly in need of a measure in to take the data in Table 1 and represent it as displayed in table two. Essentially I need a measure that counts sales only when the sale is of an SKU that hasn't already been sold in a prior date in the table, and then a running total of the first measure. Completely lost, any help would be greatly appreciated. Thank you. Table 1 Table 2
