Sequence Number or Serial Number or Row Number in Power BI DAX Tutorial (31/50)

[@QuantumIdeas]

I have been scratching my head on how to sort my calender table with a date column that is used as a slicer selector. It seems that I can't get rid of a circular error when I create a Column to use as a sorting vaue to sort the date. Until I come across this video. I was searching the DAX manuals for Index/Rownumber/Row functions could solved my problem. And voila, Nags just demonstrated the workaround. Thank you, Nags.

[@AnalyticswithNags]

Thank you

[@williamarthur4801]

Great video, neve thought of using ALLSELECTED for an index, it will prove useful as I often use an index or row count as a divisor.

[@AnalyticswithNags]

Glad it was helpful!

[@kickingapps8087]

This covers 1 step of two needed for my report. Can you explain how to use the dynamic serial no in a calculated column for the table? So the column value updates every time the table is filtered? And the measure value can be used in the Details of a Scatter Plot viz? Thank you.

[@AnalyticswithNags]

Not able to understand your question.

[@kickingapps8087]

@@AnalyticswithNags I would like to use the serial number (as created in the video) in a scatter plot (Details). However, you cannot use a 'measure' in the 'Details' of a Scatter Chart. When a user filters the report, I'd like the labels (details) in the scatter chart to reflect the serial numbers that are generated based on your method.

[@christinemak7120]

how can i add sequence of just 1 and 2 this can help me divide my table into two lists, ones and twos.

[@gilsonjunior_narrador]

Thank you Sir ! I wanna do that with fact table, is it possible ? Cause I got the number of records I have each ID i have. Thanks

[@AnalyticswithNags]

As I said if you have Id column then it is easy. Will make a video soon when there is no iD column

[@ramakrishna3122]

Hi , In my table i dnt have values in a single column .. but I want to get row nums what's it

[@AnalyticswithNags]

Combine the columns to form a unique value per record

[@BhaktiDiarys]

Create an index column and then use the index in dax

[@RaviKumar-gz9my]

It Worked. Sir. Thank you. Appreciate. If I Sort Quantity in Table, Will it display 1,2,3 to Last Number in Serial No.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@abdulkhadershaik4738]

First video in the playlist which I did not quiet understand.. If you could have explained with some diagram for people new to PBI would help a lot. Getting tough to visualize two tables..

[@AnalyticswithNags]

are you new to powerbi ?

[@yassminjahoune9121]

What if we have the same OrderLineNO , the Serial No gonna be the same or it's gonna be different ?

[@AnalyticswithNags]

It depends on how source system designed their systems

[@waseemalam9649]

How did you add orderline colum in power BI?

[@AnalyticswithNags]

It is part of fact table

[@waseemalam9649]

@@AnalyticswithNags Can you share that link of your video?

[@lindabond9307]

Unfortunately this does not work for lists with many rows (thousands?) which is a shame

[@AnalyticswithNags]

Not sure.

[@kaknannty3402]

YES, Mine is 10k ++ lists and it gets error every time it loads based on filter. Do we have any workaround for this?

[@sanc7753]

Hi sir . 1 question:it is similar to the autonumber has128 in qlickview please reply

[@AnalyticswithNags]

Yes, it is

[@sanc7753]

Sir one help..please ...how to I convert this in power bi If (autonumberhash128(a)=previous(autonumberhash128(a)),peek(a + an)) as an

[@georgedarakji1954]

@@AnalyticswithNags What if there is no OrderLineNo column and all columns in the table are descriptive text?

[@VimalKumar-kz6yg]

@analytics with nags pls help on this question There should be some unique number Is it mandatory some unique value should be there to generate 1,2,3 searal number

[@BhaktiDiarys]

@@georgedarakji1954 Create an index column and then use the index in Dax

[@zakeerhussain9961]

Please provide source for practice purpose