Create a sequence of number for accounting

[Anonymous]

Hello Power BI expert,

I'm trying to create a sequence of number in Power BI based on a criteria for an accounting dashboard, I have the following data already shaped in Power BI on previous calculation:

Company Code	Records	Type of Records	Company + Type of records	Debit	Credit
1050	Record B	B	1050B	0	20752
1050	Record B	B	1050B	20.752	0
1050	Record C	C	1050C	0	1379
1050	Record C	C	1050C	1.379	0

Now I would like a create a new column of sequence of number (made by couple) based on the field  "Company code + Type of records",for the  for example:

Company Code	Records	Type of Records	Company + Type of records	Debit	Credit	New Field
1050	Record B	B	1050B	0	20752	1
1050	Record B	B	1050B	20.752	0,00	1
1050	Record C	C	1050C	0	1379	2
1050	Record C	C	1050C	1.379	0	2

The objective of the sequence is to isolate the records in debit / credit transaction for all the companies in my database (with different transaction).

It's possible to do this in power BI?

Thanks in advance!

[vojtechsima · Accepted solution]

Hi, @Anonymous 
I am not sure if I get all your requirements right, however, this looks like it could be it:

Sequence = RANKX('Table (2)', 'Table (2)'[Company + Type of records],,ASC, Dense)

[Anonymous]

Thank you very much, it seems work as expected!