Forum Discussion
Total Per Month
Hi, JB17
Based on your information, I create a sample table:
Then unpivot columns, like this:
Select Close & Apply. Create a table visual, put the date, status, and values in the table, and then date selection to leave the month. Here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JB17 - If I am right in my interpretation, all of your dates are in different columns, if this is the case you need to un-pivot your data in Power Query first, I have written a blog about this here: https://triangle.im/power-bi-mistake-5-why-pivoted-data-leads-to-power-bi-pain/
and you can find more guidance on doing it here: https://learn.microsoft.com/en-us/power-query/unpivot-column
Once you have done that you can add a new column to your table that will give you the month year in your desired format, or hook up a date table (this would be my choice) - here's a blog on that: https://blog.enterprisedna.co/introducing-power-query-extended-date-table-v2/
and simply sum the new column that has your values in.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!