Need help creating a new Counter in Table

[olsen9]

Whenever the report is refreshed and updated, was looking to see a new column added called ID that starts with 1 then each row is 2, 3, 4, 5 etc

[Anonymous · Accepted solution]

Hi  @olsen9 ,

You can try the following measure to show the dynamic index.

RowNum = 
CALCULATE (
    COUNT ( 'Table'[ID] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[ID]  <= MAX ( 'Table'[ID]  )
    )
)

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: How can I create a simple index column with dax. - Microsoft Power BI Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @olsen9 ,

you can call a stored procedure during the import that is incrementing the value or adding one in a table.

This table you can then return as a result of the stored procedure.

To make your life easier, I personally would just return the last refresh date/time. But the approach I just mentioned should give you the result you want.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[olsen9]

Thanks, I probably should have said I'm using data in SP online.  No access to SQL