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

Super User

5 years ago

Hi Sam,

In Power Query, I'd be inclined to select all of the columns that are consistent, right click and choose 'Unpivot other columns' as one of the first steps. This will give you the consistency you need to work with in your measures.

Regards,

Kim