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

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

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