Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
134 | |
71 | |
70 | |
54 | |
52 |
User | Count |
---|---|
205 | |
95 | |
63 | |
61 | |
54 |