Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamic column name based on a column value coming from a different unrelated table

Hi,   I have a requirement to get the column name (for Table A) that can change dynamically based on column value that is coming from a different table (Table B) which is not related to this table ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks rajendraongole1 

When I rename it manually after the last step "Removed columns" and then try to test it to change a date for one column (Column1) and then refresh both the table it is throwing an error and not replacing the column name!
Up to here it's all good and change the column1 date from 22/05/2024 to 11/06/2024

 

However, as soon as I add a step to rename from "11/06/2024" to "Column1 - 11/06/2024", it is throwing an error as per below!

 

Also, placing screenshot of the advance editor so you can see all the steps - 

 

Please advise.

 

Thanks

Brij

 

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi Anonymous - If possible, can you share the pbix file in one drive , i will check and upload it back to you. 

please check the last two steps, rename column before that are you able to see the data?

 

if yes, please share the snapshot?

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rajendraongole1 

    I am not able to upload the pbix for some reason!

     

    Brij

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion
    2 years ago

    You will need to reply with a sharing link from a cloud based service such as OneDrive, Google Drive, BOX, Dropbox or similar.