Forum Discussion
Nicole_H
2 years agoFrequent Visitor
Dax to Power Query
I've spent way too long on this, and can't get it to work. Can anyone covert this Dax into PowerQuery please? I am not sure if it can be done. The DAX code repeats [Extract_Measure] for each ID...
- 2 years ago
I updated my answer, hope this works for you
let Source = TableName, GroupedTable = Table.Group(Source, {"ID"}, { {"NewMeasure", each let form_id = Table.FirstN(_, 1){0}[ID], FilteredTable = Table.SelectRows(Source, each [ID] = form_id and [Answer] = _[Extract_Measure]{0}), MaxValue = List.Max(FilteredTable[Extract_Measure]) in MaxValue } }) in GroupedTable
Nicole_H
2 years agoFrequent Visitor
Sorry ronrsnfld, I'm using really sensitive data, which is why I gave a vague example, but if the other solutions don't work I'll try and attach something. Thanks
ronrsnfld
2 years agoSuper User
If you do, use made up data that reproduces your problem. Don't use real data.