Add Query Name as a Column

[Anonymous]

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.

[ChrisMendoza]

Did you try https://radacad.com/get-list-of-queries-in-power-bi ?

[Anonymous]

@selimovd @Ashish_Mathur can you help me here?

[selimovd]

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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[VBVB]

Just what I needed it 🙂 thank you very much!

[Anonymous]

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.

[selimovd]

@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.

[Anonymous]

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.