How to add index/serial number with each row in the visual?

[sam888]

Hi, can someone please help me with this:

I have a table called employees, it has multiple columns like name, start date, end date. I have formed a visual where end date is greater than december 1, 2001. Now it displays the list of these people who started after that date, but how can I put a serial number against each row so it's easy for user to see how many employees are there that fit this criteria?

[Ashish_Mathur]

Hi,

Drag this measure to a card visual

Measure1 = countrows(filter(values(Data[Name]),Data[End date]>=date(201,12,1)))

Hope this helps. 

[FreemanZ]

hi @sam888 

you may add an index column in Power Query editor. 

https://support.microsoft.com/en-us/office/add-an-index-column-power-query-dc582eaf-e757-4b39-98e6-b...