Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Wondering how to do something as follows:
Order # | Error
Order 1 | Something
Order 1 | Something else
Order 2 | null
Order 3 | Something
I want a column or a table that says something like this:
Order # | Error Count
Order 1 | 2
Order 2 | 0
Order 3 | 1
Any ideas?
Solved! Go to Solution.
You can use "Group By" in the query editor.
In order to create base code, you can choose to sum the "Error" column and then adjust the generated code to the code below.
let Source = Input, #"Grouped Rows" = Table.Group(Source, {"Order #"}, {{"Error Count", each List.NonNullCount([Error]), Int64.Type}}) in #"Grouped Rows"
I tried to do that, but it wouldn't let me. That is because the error column is text, so it is not letting me use the sum operator
Ah, forgot to tell. Sure you will get errors at first, just ignore these and adjust the code, then you'll be fine.
Like this:
Wow, thank you so much, this was really helpful.
One last question. I want to either append this column to the original table, or create a new table without altering the first table. How do I do this?
Just save & load the query with a new name, then you'll have your new table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |