I have a table similar to below:
Which I want to convert to:
I tried pivoting the columns but that only seems to work well for the dates. Not sure how else to proceed. Any help appreciated.
Go to Solution.
There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on
Then you would have 3 tables
Here you can just do an append and have it all in 2 columns
View solution in original post
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.