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 

I have tried to follow the steps you provided, however, I'm getting errors when applying the step - adding columns "Column1 - Extract Date". See below

 

It would be great if you could attach pbix so I can check where I am making mistake or if you could explian please?

Thanks

Brij

 

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

Hi Anonymous - I am not able to attached my pbix file here,option not available.

 

you almost reached towards the solution. 

 

after merge queries, during the expanding option you can remove the original prefix and continoue to add the new custom columns, it works

 

 

 

Check and confirm

 

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 for your help.

    I was keeping the original prefix hence it was throwing an error! But after removing it I can move forward.

    I am almost there. Now I can see the dates as the column header for the relevant columns however, the original column labels is not appearing along with the dates! I can see it on your last step, but how did you get it? Pleaes advise. Thanks

     

    • 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