Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |