How to tag the order in which invoices have been time stamped?

[Anno2019]

Hi Guru's

Hope someone can assist me.

I am looking for a way to tag the order of which an invoice "IN" [Voucher Type] was made with the following rules.

Look in [File Number] and only look for [Voucher Type] "IN", if the the invoice was the first time stamp then Tag as 1, if invoice was the second time stamp then 2, if invoice was third time stamp then 3 etc etc etc.  if [Voucher Type] is not "IN" then blank.

My table below include two seperate file numbers with various vouchers, my end result I have included in [Voucher Order TAG].

Would really appreciate some help.

File Number	Voucher No.	Voucher Date Time	Voucher Type	Voucher Value	Voucher Order TAG
ZRTQW190000005	9050000164	08 Aug 2019 13:23:09	YQ	16 091
ZRTQW190000005	9050000285	20 Aug 2019 11:06:45	IN	3 728	1
ZRTQW190000005	9050000919	28 Aug 2019 20:44:08	ZE	360
ZRTQW190000005	9050001183	02 Sep 2019 13:16:12	ZE	125
ZRTQW190000005	9010001244	14 Sep 2019 13:32:42	IN	45 934	2
AAWTEC99847661	9010001246	14 Sep 2019 13:33:06	IN	4 604	1
AAWTEC99847661	9010001247	14 Sep 2019 13:33:38	IN	18 383	2
AAWTEC99847661	9040000170	14 Sep 2019 14:22:04	RB	23 268
AAWTEC99847661	9010001255	14 Sep 2019 14:22:30	IN	23 044	3
AAWTEC99847661	9050002005	14 Sep 2019 17:50:42	PP	5 472

[v-juanli-msft]

Hi @Anno2019 

Create a measure

Measure =
IF (
    MAX ( Sheet2[Voucher Type] ) = "IN",
    CALCULATE (
        COUNT ( Sheet2[File Number] ),
        FILTER (
            ALLSELECTED ( Sheet2 ),
            Sheet2[File Number]
                = MAX ( Sheet2[File Number] )
                && Sheet2[Voucher Type] = "IN"
                && Sheet2[Voucher Date Time]
                    <= MAX ( Sheet2[Voucher Date Time] )
        )
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anno2019]

@v-juanli-msft 

This also worked perfectly as a measure.

[amitchandak · Accepted solution]

create a new column like one given below

countx(filter(table,table[File Number] = earlier(table[File Number]) && table[Voucher Type] ="IN" && earlier(table[Voucher Type])="IN"
&& table[Voucher Date Time]<=earlier(table[Voucher Date Time])),table[File Number])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anno2019]

@amitchandak 

Worked perfectly!!!  Thank you!!!