Index Calculated columns

[Anonymous]

Hi

I need to  add the calculated index column to the table by a DAX formula. 

Rgds

Henrik

[Anonymous]

Hi all, thanks for reply!!

I`ll try to clarify. This figure might help. 6121/TEST-LINE-1 is the "mother" of "6121/ST-TESTPIPE" with "children-ID`S.

It`s all about to get Test-Line-1 in first row and ST-TestPipe in second row with children ids etc..

If you have a solution that would be great. Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous,

It seems like a multiple column sort recruitment, maybe you can take a look at following thread about using isonorafter to sort multiple columns:

Sorting by multiple columns 

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Basis what do you want to create the Index column - the first 4 characters of the Key column?  Clarify.

[Greg_Deckler]

Seems like a variation of Cthulhu - https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/td-p/509739

[FrankAT]

Hi @Anonymous 

I think you have to do it with Power Query like this:

// Table
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("pdM9DoAgDAXguzBrLC0qjEY8AWzGG3j/2Z9oECbiSxgK6fdoQlhX5VhTF5cQVaO+i2n2YkSrrcmb7noi/ZbXcbsXjvt6l3acRQx4xIhHWDzCwRFC+BTmE1G8tSEfWDTnHc8NnDJLIBUgjSOZNYDtATsAdgSsBaz7b5kAe37+7QA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t, D = _t, E = _t, KEY = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", type text}, {"D", type text}, {"E", type text}, {"KEY", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"A"}, {{"Gruppieren", each _, type table [A=text, B=text, C=text, D=text, E=text, KEY=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Index", each Table.AddIndexColumn([Gruppieren], "Index", 1, 1)),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Index"}),
    #"Expanded {0}" = Table.ExpandTableColumn(#"Removed Other Columns", "Index", {"A", "B", "C", "D", "E", "KEY", "Index"}, {"A", "B", "C", "D", "E", "KEY", "Index.1"})
in
    #"Expanded {0}"

Regards FrankAT

[az38]

Hi @Anonymous 

Try a column

Index = 
RANKX (
FILTER('Table','Table'[A] = EARLIER('Table'[A])),
'Table'[KEY]
)

[Syndicate_Admin]

it works perfectly. Thanks.