Forum Discussion
Extracting Date and Converting to a Column | Need Help
Finally solved my issue, though in a very crude and manual way using the power query options.
If you have a report like mine where the date is on a row and not on a column, and you need the dates for all rows. Here's what I did:
1) Remove top 3 rows to leave the date on row 1
2) Filter column 1 to only show the date, for my case filtered by: "Period: From"
3) The filter will only show rows that has that text.
4) Then using "Add Column by Example" capture the dates.
5) Then delete the filter step, so you report shows back up with a column that has a date and blanks
6) Replace the blanks with null
7) Click the new date column and fill down, this will place the dates across all rows.
Finally solved my issue, though in a very crude and manual way using the power query options.
If you have a report like mine where the date is on a row and not on a column, and you need the dates for all rows. Here's what I did:
1) Remove top 3 rows to leave the date on row 1
2) Filter column 1 to only show the date, for my case filtered by: "Period: From"
3) The filter will only show rows that has that text.
4) Then using "Add Column by Example" capture the dates.
5) Then delete the filter step, so you report shows back up with a column that has a date and blanks
6) Replace the blanks with null
7) Click the new date column and fill down, this will place the dates across all rows.