Forum Discussion
How to create clustered column chart using 2 date columns from the data table
The final result should look like this (Done using Excel) with running 12 months data up to current month. The dataset has 2 columns. One has Opened Date and Closed Date. Both are Date colu...
Hi rouelandrew
1st Problem
In Power Query, select the Opened Date and Closed Date columns, then use the "Unpivot Columns" option. This should transform your data into a long format, where you have a column for the attribute (Opened/Closed) and a column for the value (the actual dates).
2nd Problem
You might consider creating a measure that calculates the running total of opened cases and then subtracts the closed cases for each month.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, as mentioned in my post I did try Unpivot but when I do that the data doesn't line up or is accurate. What am I doing wrong?
Yes that is what I did.