Forum Discussion
Serial Number in a Report
Hi,
We have created a report in Power BI
Datasource : Connect Live to SSAS Tabular Model
We need one column to display Serial Number (Row Num) in a report
Add Index is disabled -- since we are using connect Live option
Can you pls suggest?
1 Reply
hi GuestUser
Since your data source is SSAS Tabular Model, you could only create measure for this report in power bi,
you could try these two ways:
1. Add an index column in SSAS Tabular Model.
2. Use RANKX Function to create a rank measure and use it as a Serial Number.
https://docs.microsoft.com/en-us/dax/rankx-function-dax
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/
Regards,
Lin
