Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query Editor Count of Unique Column Values Into Two Columns

I have two columns in a Table as seen below. Store Number Audit Violation 8297 Failed Audit 8297 Passed Audit 8297 Failed Audit 8297 Passed Audit 8297 Passed Audit 8291 F...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Anonymous ,

    In case you still want to do it in PQ Editor.

    = Table.Group(#"Changed Type", {"Store Number"},
{{"Count Failed Audits", each Table.RowCount(Table.SelectRows(_, each ([Audit Violation] = "Failed Audit"))), Int64.Type},
{"Count Passed Audits", each Table.RowCount(Table.SelectRows(_, each ([Audit Violation] = "Passed Audit"))), Int64.Type}})