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.
Hi all,
I have a table with data from SQL Server, and I would like to have the following solved:
In my table, I have rows where some columns have same values, but in other column a unique value.
Now, I'd like to group the values which are the same, show the totals of the unique value.
This the current situation:
Now I wish to have a result like this:
CustomerNumber | PosTotal |
24122-A | 10 |
How can I achieve this? Thanks for the feedback.
Solved! Go to Solution.
Hi @mariosss45 ,
You can make use of "Group By" option from the Transform section of the Power Query editor and can select the required columns using which you need to group by the data by selecting the required aggregation function.
1) You will have to select the levels by which you need to group by and select the POsTotal column aggregating it to Sum as shown below
And this will give you the below grouped results
Hope this helps!
Please accept the solution if this answers your query.
Thanks,
Avantika
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |