Forum Discussion

Sachin31's avatar
Sachin31
Regular Visitor
4 years ago

Auto Increment Sequence number on Summarized Table visualization

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...
Need Help
mh2587's avatar
mh2587
Super User
4 years ago

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

  • Sachin31's avatar
    Sachin31
    Regular Visitor
    4 years ago

    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's avatar
      mh2587
      Super User
      4 years ago
      Row Number = RANKX(
ALL(TableA)
,% Time Recorded) //I am assuming the % Time Recorded will be a measure not calculated column

       

      • mh2587's avatar
        mh2587
        Super User
        4 years ago

        Write this measure and put it in the visual