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

     

ronrsnfld's avatar
ronrsnfld
Super User
2 years ago

Please provide some usable data (as text, not a screenshot) along with what you expect for results from that data, and the logic required to go from Source data to Results.

  • Nicole_H's avatar
    Nicole_H
    Frequent Visitor
    2 years ago

    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's avatar
      ronrsnfld
      Super User
      2 years ago

      If you do, use made up data that reproduces your problem. Don't use real data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Nicole_H 

      Have you resolved this issue? If any of the answers provided were helpful, please consider accepting them as a solution. If you have found other solutions, we would greatly appreciate it if you could share them with us. Thank you!

       

      Best Regards,
      Jing