This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hello Community,
I need help in creating a column with default value. I have a dataset with 2 columns and i want to create 3rd column with default value like(Same value for all records).
Dataset :
ID Name
1 Arjun
2 Deep
Output:
ID Name Age
1 Arjun 27
2 Deep 27
Thanks,
Paruchuri
Solved! Go to Solution.
Hi @Anonymous
will new column with constant value help?
Context menu "new column" ->
Column = 27
or it's too simple?
Best regs
Fine, @Anonymous,
try this:
Column2 = "https://www.google.com"
double quotes is important for text value
best regs
Hi @Anonymous
will new column with constant value help?
Context menu "new column" ->
Column = 27
or it's too simple?
Best regs
Thanks It is working. I am trying to create one more column with default value 'https://www.google.com' to all records but getting error.
The syntax for ':' is incorrect. (DAX(https://www.google.com)).
Fine, @Anonymous,
try this:
Column2 = "https://www.google.com"
double quotes is important for text value
best regs
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 25 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 24 | |
| 20 | |
| 20 | |
| 19 | |
| 19 |