Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Is there a way to create new columns in a query based on a separate data query? I would like to accomplish something similar to a pivot table where you can assign a data field as the columns and have the row values be determined by the column
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |