Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
New to PowerBI and doing a lot of training right now.
I hope an easy question: how to add a new column in table with same value for all rows.
To add a column is known, but how to set a new single value for all rows with one command?
Thank you!
Solved! Go to Solution.
In the Query Editor, go to > Add Column > Custom Column >
In the custom column formula something like = "abc" will create a column of all "abc" values
I would like to know if this works with incremental refresh or not.
lets assume that i am adding a custom column in my table and setting value = "abc" for example , all the cached rows will have a value 'abc' for a custom column but after every incremental refresh , will new rows have the same value ?
would be great if you can help.
Thank you
How do you read the solution? When I click on it it just takes me to the bottom of the page.
Solved, found the answer...
How do I read the solution? When I click the link it takes me to the bottom of the page.
Hello,
I found it here:
Add a custom column, give it a name and enter the value as formula like "ABC"
That's all...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |