Forum Discussion
Extracting date from poor source data format
Hi all, I have a live query to an SQL server returning some finance fields and the source data is as per table below. B_Jan, B_Feb, B_Mar are the amounts invoiced to a customer in a given month. ...
I would turn off direct query and import the data, but I would transform it in the PBI Desktop Edit Queries window. The Unpivot Columns transformation will twist those columns into rows, to get a useable result. Queries can also automate splitting the column headers and converting the Months into dates.