Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have below queries in my dataset. I need to add a column with value as the query name in both the queries.
For Instance, Query1 has below tables:
And I need to add a column as below:
Is there any option to add custom column like this? Please help me.
Did you try https://radacad.com/get-list-of-queries-in-power-bi ?
Proud to be a Super User!
Hey @Anonymous ,
yes, that's easily managable.
Go to Power Query to your Query1, then choose "Add Column" --> "Custom Column" and then add the Text "Query1":
Afterwards the column will appear in your table.
Hello, Thanks for your reponse.
Sorry, I need to be more clear on my requirement. My Query name is dynamic, Everytime, its not possible to go and change the text in the Custom column step.
Instead I need a step to add the name of the Query name.
@Anonymous then tell us where you get the dynamic name from and I might find a solution.
By the way, if you answer always mark people with an @- Symbol. Otherwise I will not be informed about the new reply.
the dynamic name is the Query name only. I need to get the Query name as a column values.
is there any custom column functions to get the required output. Please refer to the images attached in the initial query.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |