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.
I am working in Power Query and I pivoted a column and now I want to get a totol of each Months out.
How would I go about doing that.
Here is my sample data (spreadsheet) - Pivot Total Column Sum
Thank you for any help you can give.
Chad
Solved! Go to Solution.
I need the totals of each row 0 -12 like this. With the article I included in this post I was able to solve how to get them but in order to do that it takes away the 2020-11 - 2020-05 months for example.
Thank you.
Chad
Actually this helped for getting the sum but I also need a way to still show all Pivot columns which is the 2019-11 thru 2021-11. If anyone can help I would greatly appreciate it.
Thank you.
Chad
Hi @MP-iCONN ,
Is that u have successed reach the result you want?
1 Maybe you need to remove the [Months Out] and add costum column via =1, then select the costum column and unpoived other columns.
2 Pivot column -> and select value in the Values Column.
the result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I need the totals of each row 0 -12 like this. With the article I included in this post I was able to solve how to get them but in order to do that it takes away the 2020-11 - 2020-05 months for example.
Thank you.
Chad
Hi @MP-iCONN ,
You mean 2019-11 + 2019-12 + ... + 2020-05?
If yes, add a custom column
this will get the total result of each rows
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solved it with this - https://www.edureka.co/community/42820/dax-sum-of-values-from-many-columns-in-a-row
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 |
---|---|
114 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |