Forum Discussion
Source Data has all dates as column headers
Q1. Your assumption is correct. Much easier to work with date data as rows.
Q2. Because there are numerous areas the date is entered (seemingly at every 'Category' of data) we will need to filter then unpivot your data.
To start, I'm assuming your data is coming into Power BI similar to this:
We will promote headers then filter out other date junk in the same column.Now the table should look like this
Select the first column (mine is membership) and Transform > Unpivot Columns > Unpivot Other Columns
Rename a few columns and you're done!
Q1. Your assumption is correct. Much easier to work with date data as rows.
Q2. Because there are numerous areas the date is entered (seemingly at every 'Category' of data) we will need to filter then unpivot your data.
To start, I'm assuming your data is coming into Power BI similar to this:
We will promote headers then filter out other date junk in the same column.
Now the table should look like this
Select the first column (mine is membership) and Transform > Unpivot Columns > Unpivot Other Columns
Rename a few columns and you're done!
I wish I asked before googling, watching way too many youtube tutorials and just experimenting.
That worked exactly as I hope and was simpler than I tried to make it. Thank you!