topic Re: Dax Index column Filter after name in DAX Commands and Tips

Dax Index column Filter after name

Anonymous — Thu, 19 Nov 2020 14:41:26 GMT

Hi guys,
I need an index column that starts first, as soon as an object name is in another column If there is nothing in the column, nothing should be returned:

ObjectName	Index


Object1	1
Object1	2
Object1	3
Object1	4
Object1	5

Object2	1
Object2	2
Object2	3

Thanks in advance

greetings Lukas

Re: Dax Index column Filter after name

CNENFRNL — Thu, 19 Nov 2020 15:02:03 GMT

Hi, Anonymous , it's fairly easy to achieve what you want in Power Query; you might want to try this,

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8k/KSk0uMVSK1SGXbYSbHQsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ObjectName = _t]), #"Sorted Rows" = Table.Sort(Source,{{"ObjectName", Order.Ascending}}), #"Grouped Rows" = Table.Group(#"Sorted Rows", {"ObjectName"}, {{"All", each Table.SelectColumns(Table.AddIndexColumn(_, "Index", 1, 1, Int64.Type), {"Index"})}}), #"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"Index"}, {"Index"}) in #"Expanded All"

Re: Dax Index column Filter after name

Anonymous — Fri, 20 Nov 2020 08:59:59 GMT

Hello CNENFRNL I created the ObjectName Column with Dax (I get the Name form another Tabel) so I cant do this with Power Query