Video

Perfect! Simple and exactly what I needed.

This is a good solution, but only for a specific use-case. I still cannot imagine what the people at Microsoft are thinking for not making the headers of table-columns much more flexible in the first place. I would like to use some kind of lookup-table to maintain all column-headers at a central place - since many of the headers are used many times over in different report pages and many different visuals - not to speak of translation and flexible switching of languages. But Power BI is not open and dynamic enough to allow this and forces one to create massive redundancy instead. Power BI is a typical case of a tool where you more sooner than later realize that those who develop it never have to work with it in real life. Otherwise a thing like dynamic headers pulled from a single central table lookup would be a self-evident thing that works out of the box. Such things even worked in fat-clients like MS ACCESS 30 years ago already. Nowadays everything LOOKS totally 'dynamic' - but in fact it isn't.

Apparently interesting solution but it won't work if the current month number is lower than 6 as it have to subtract 1 from the year too. Also it can not be applied to filtered (by slicer) values as the parameter does not recognize such filters. I tried to name the several columns based on periods back from a period selected by a slicer and the proposed solution does not work. Any idea how to change the table column names based on a date period selected by a slicer?

i'm getting only one column when i select the parameter and under them displaying values of all them with plus sign to expand. please assist what to do in order to fix it

Totally loved it. Keep it up brother.

Not the exact solution I was looking for but still a very helpful video

Passed selectedvalue from slicer as text in similar parameter, but its not displaying the values, can you please help?

will it work in pivot table?

Wow

Oh, I like this!

Thanks! question for you, what if the page number is hidden in the metadata, for example: dailymed.nlm.nih.gov/dailymed/services/v2/ndcs.xml , this will only give me the first 100 records... any thoughts?

Very clever solution indeed.. Thank you :)

Wyn Hopkins covered "How to Rename Column Headings with Power Query - the quick automated way" 😉 czcams.com/video/91pv9ewq_JM/video.html

This is very helpful. Very well explained!!

बहोत आछ्या है

Great! That exact I was looking for! Thank you so much! Sorry for late answer

Thanks buddy. Nicely explained😊

Finally a video giving a clear and simple explanation! Thank you so much

Great vide! If the number of pages is not constant - Is it possible to automate this process? If the number of pages is available on page

Nice, I like your last solution with a list. I can imagine a huge use of it when having some huge list.

Thanks. So precisely explained. You are truly a gem bro!

Helped me a lot. Hoping to help you by commenting!

Big thank to you. Very well explained. Cheers!

You are the man's raw material bro. It was very useful. Thanks.

very helpful

Thank You

Nice

I created a similar parameter but the fields in the parameter are not displaying the totals. Can you please help?

Very Helpful!!!

Very Helpful. i was looking for this solution for past two years now.