Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tferenc80
New Member

Taking over column from a table into another table dynamically

Hello All! I have a problem that I cannot solve.

 

So I have table 1 with columns of which headers are calendar week numbers. So 41, 42, 43, etc. This comes from a sharepoint xsl file and will have further columns as the time goes.

 

Now I have another table where I want to have the same data but with a defined delay, which can be changed. So I say that the delay is now =2, and then column 42 from table 1 should appear in table 2 as column 44.

 

Can anyone recommend a solution for this?

2 REPLIES 2
Anonymous
Not applicable

Hi @tferenc80 ,

 

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.


Best Regards,
Eyelyn Qin

Anonymous
Not applicable

Hi @tferenc80 ,

 

Your requirement may not reach currently... All I could do is select columns and rename them like this:

Table =
SELECTCOLUMNS ( 'Table1', "44", [42], "45", [43] )

11.30.4.1.PNG

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.