Auto Increment Sequence number on Summarized Table visualization

[Sachin31]

Hello All,

I have a PBI report in which i have added a table , the column of tables is summarized view of data means it grouped data on behalf of some column and shows there.
Now i want to have a automatic unique sequence number on this summarized table visualization , I tried adding index column in source data power query editor but since on table visualization data is getting sum , this unique value also gets sum multiple times and shows a big number which is not good.
i want something to generate on visualization itself.
I tried creating table from this visual and adding index column on that custom table , but custom table doesn’t come in query editor

[mh2587]

Can you please share the expected out or some other details of the issue with screenshot or dummy data

[Sachin31]

Hello @mh2587 ,Please see the screen shot below , This report shows Employee Timesheet Status monthly.

in another table(Table B) i have each employee daily timesheet , which i am summarizing here to get the total hours and missing hours till the date. 

I want a custom index column in Table A which will start with 1 , and as the rows increases in the table it will take +1 increment. its fine if foe the next month it will continue the series and will not start from 1 again. 

Table A

Table B

Kindly let me know if you need any further details , Thanks in advance.

[mh2587]

Row Number = RANKX(
ALL(TableA)
,% Time Recorded) //I am assuming the % Time Recorded will be a measure not calculated column

[Sachin31]

Hello @mh2587 , here in tableA which table i should mention because all tables have data on daily basis activity and in this visual i need grouped(till the date) result. 

[mh2587]

I didn't get you please provide expected output and the logic you are thinking 

[Sachin31]

hello @mh2587 , i am doing it other way , i am storiong data to share point list and SP list ID i am usnig as Index for my email in flow.

Thank you so much for all your help and efforts 

[mh2587]

Write this measure and put it in the visual

[mh2587]

You can select the don't summerize option in column field or simply convert the data type to text of this column

[Sachin31]

Hello @mh2587 , Thanks for looking into this ,

That wont work in my case because on that visualization i want summarized values and since this index column i have added in in source table , it will summarized the values , if i will make it do not summarized or text , that table visualization will show wrong(individual/ non summarized ) data for all columns