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...

Need Help

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

Ashish_Mathur

Super User

5 years ago

Hi,

If on July 4, 2021, you receive a file which starts with Jul-21, then will this file replace the file which you received in Jun-21? If yes, then how will you get access to the Jun-21 figures when it is Jul-21?

Sam_Bolsover

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

Ashish_Mathur
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.

Forum Discussion

How to handle data source column headers changing?

Related content

Handling Null Values

How do you handle semantic model name changes and schema differences during merges?

Handling schema changes and multiple schemas in Eventstream

Paginated Report headers not repeating

Handling Missing Columns in Combined Files to Maintain Header Alignment