Dynamically update the column header

[vijayvizzu]

This looks same as previous post., but the solution was not provided correctly. The URL was not working.

I appreciate if anyone helps to provide the solution.

https://community.powerbi.com/t5/Desktop/Source-Data-Column-Header-Changes-each-month/m-p/541727#M25...

My dataset is a financial report showing actuals and forecast. July - June.

Example (4 Columns)

Actual July 2018

Actual August 2018

Actual September 2018

Forecast October 2018

I have prepared a visual based on these current column headers.

However next month when the report is run the column "Forecast October 2018" will become "Actual October 2018".

[V-lianl-msft]

Hi @vijayvizzu ,

Refer :

https://www.youtube.com/watch?v=yBJr0sAc-m4 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@vijayvizzu , refer on of these can help

dynamic Column Header
https://www.youtube.com/watch?v=yEemVBiaTuk
https://www.goodly.co.in/dynamic-column-names-power-query/
https://www.thebiccountant.com/2018/07/04/efficiently-rename-column-names-with-a-function-in-power-b...
https://community.powerbi.com/t5/Desktop/Dynamic-column-name-from-its-value/td-p/189442