Forum Discussion

Nicole_H's avatar
Nicole_H
Frequent Visitor
2 years ago
Solved

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...
Need Help
  • aduguid's avatar
    aduguid
    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

     

aduguid's avatar
aduguid
Memorable Member
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's avatar
Nicole_H
Frequent Visitor
2 years ago

Thanks for your speedy reply!  Although I don't get a syntax error the new column is returning Error, not sure what I have done wrong (or what I'm doing at all to be honest!)