Forum Discussion
Solved
Dax Help : Conditional Index
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
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
3 Replies
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
Thank You very much PhilipTreacy
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!
