How do I retrieve a particular group cells
value (date) displayed in a row in the datasource from Power Query.
I need to be able to retrieve these values (date) and set them as the column header. However when I attempt to use promote to column header, it fails and does not display the dates as column headers, but does display the text/value from the other columns without issue.
what am I missing? Need urgent assistance.