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
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Great Anonymous - if it works, mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 

last step you can rename it.

 

 

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 

 

So it need to be changed manually?

 

And yes, I will mark this as solution.

 

Please let me know.

 

Thanks

Brij

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

    Hi Anonymous - yes, we have to change it manually to rename. 

     

    Thank you Anonymous 

     

    if you acheive the solution.please mark it.

     

    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

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

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

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