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,
I am trying to use power query to automatically insert rows to existing table based on a list of dates that I can obtain from the existing table. The table has project name, date and amount. I am trying to sum up certain projects for each date.
Old Table:
Project Date Amount
proj1 1/1/2019 10
proj2 1/1/2019 10
proj3 1/1/2019 10
proj1 1/2/2019 20
proj2 1/2/2019 20
proj3 1/2/2019 20
New Table:
Project Date Amount
proj1 1/1/2019 10
proj2 1/1/2019 10
proj3 1/1/2019 10
proj1 1/2/2019 20
proj2 1/2/2019 20
proj3 1/2/2019 20
projSum 1/1/2019 30
projSum 1/2/2019 60
Can this be done?
Thank you.
Solved! Go to Solution.
You can do this in Power Query, though I'm not 100% why you want to materialize this figure when a measure would be better suited, but maybe you have a reason.
You can see the applied steps, but quickly:
1. Duplicate original table
2. Group this table by Date, and Aggregating by Sum of Amount
3. Add a column named "Project" and enter in "ProjectSum"
4. Append your main table with table
5. Turn off "enable load" on the Append table
file:
You can do this in Power Query, though I'm not 100% why you want to materialize this figure when a measure would be better suited, but maybe you have a reason.
You can see the applied steps, but quickly:
1. Duplicate original table
2. Group this table by Date, and Aggregating by Sum of Amount
3. Add a column named "Project" and enter in "ProjectSum"
4. Append your main table with table
5. Turn off "enable load" on the Append table
file:
I got it working, thank you so much! The reason why I am doing this is because I need to mannually calculate some summary value for my report. I am trying to find some automatic method.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |