Unique count of text where values display in new column

[Dan2027]

I have thousands of shipment numbers and sales documents. These numbers appear on multiple report pulls. I have cerated a date for each report pull and concatenated that date with the sales document. I want to return 1 where a unique value appears for the first time and a 0 for all other occurances. In excel i believe the forumla functions like this:

=IF(ISNA(VLOOKUP(A2,$A$1:A1,1,)),1,0)

Any help is appreciated.

Using the group by function will not fit my purposes.

Kind Regards,

Daniel

[v-sihou-msft]

@Dan2027

I assume the first occurance of "Sales Document + Shipment" should be with min date. You just need to compare the current row date with this min date.

Column = 
var FirstOccuranceDate= CALCULATE(MIN(Table1[Date]),ALLEXCEPT(Table1,Table1[Ship],Table1[SalesDocument]))
return
IF(Table1[Date]=FirstOccuranceDate,1,0)

Regards,

[Dan2027]

Simon,

I see where your going with this but i am still struggling to understand. Lets stick to just a count of sales document and date for now and ignore the shipment document. i need to count these sales documents every time they appear on the report but not multiple times per day.

Kind Regards,

Daniel