Dax Help : Conditional Index

[RENJITH_R_S]

Hello

Could you please help me to create this condition index column see the example

Name       Index

A                 1

B     

C  

A                 2

B

A                 3

A                 4

[PhilipTreacy · Accepted solution]

Hi @RENJITH_R_S 

Download sample PBIX file with this code.

This works in Power Query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclSK1YlWcgKTzmASWcQRRsYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]),
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each if [Name] = "A" then List.Count(List.Select(List.FirstN(#"Added Index"[Name], [Index]), each _ = "A")) else ""),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Index"})
in
    #"Removed Columns"

I'll see if I can do it in DAX too.

Regards

Phil

[Syndicate_Admin]

Hello

And what would it be like if I wanted him to tell me all the lyrics? For example, when sorting the names, it would look like this:

A 1

A 2

A 3

A 4

B 1

B 2

C 1

In advance thank you very much!

[RENJITH_R_S]

Thank You very much @PhilipTreacy