Forum Discussion

Frequent Visitor

5 years ago

Solved

How to handle data source column headers changing?

Hi, Each month I recieve a .csv file where each row represents a material that we order from a supplier and columns 7 and onwards represent the forcast for each month, starting with the current m...

Anonymous
5 years ago
Hi Sam_Bolsover ,

It is suggested to unpivot two column in Power Query, then select the attribute field for you title.

Reference:https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles#select-your-field-for-your-title

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How to handle data source column headers changing.pbix31 KB

Frequent Visitor

5 years ago

Hi Ashish,

That is correct. This report is solely for displaying forcast data and so information from prior months is not needed.

Best regards,

Sam Bolsover

Super User

5 years ago

Hi,

See if the technique shown here takes into account new columns that you add daily - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.