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.
Hi, i have 10tables which i need to create 3 calculated columns each - 2 sums and 1 concantenate.
hence in total, i will be creating 30 columns.
anyway to do it faster - i tried "addcolumns" but i always scalar value error.
thanks in advance.
Solved! Go to Solution.
There is no faster way than right clicking the table and coping & Pasting formulas to create calculated column. ADDCOLUMNS can be used in DAX Queries to create calculated tables.
Adding more context to your problem can lead us to provide specific answer.
There is no faster way than right clicking the table and coping & Pasting formulas to create calculated column. ADDCOLUMNS can be used in DAX Queries to create calculated tables.
Adding more context to your problem can lead us to provide specific answer.
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |