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 Experts,
I have 3 fields in my data from which I want to Create 3 conditional Columns. The Conditions are same for all the 3 conditional columns to be created. I have created a Conditional Column as COLUMN1 as per the picture. Is there a way I can use the code in Formula Bar to create 2 more Conditional Columns from other 2 fields. I don't want to type in Conditions for other 2 Columns but want to use Highlighted code.
Thanks
Deepak
Deepak
Solved! Go to Solution.
Hi drrai66,
Based on your requirement, you want to add multiple columns in one function, right?
To achieve your requirement, you can write a custom function like below:
Table.AddColumns = (table as table, addedColumns as list) as table =>
List.Accumulate(
addedColumns,
table,
(t, d) => Table.AddColumn(t, d{0}, d{1}, d{2}?))
The result is like below and you can refer to my PBIX file here:
https://www.dropbox.com/s/4b3hk747pju86h9/For%20drrai66.pbix?dl=0
Regards,
Jimmy Tao
Hi drrai66,
Based on your requirement, you want to add multiple columns in one function, right?
To achieve your requirement, you can write a custom function like below:
Table.AddColumns = (table as table, addedColumns as list) as table =>
List.Accumulate(
addedColumns,
table,
(t, d) => Table.AddColumn(t, d{0}, d{1}, d{2}?))
The result is like below and you can refer to my PBIX file here:
https://www.dropbox.com/s/4b3hk747pju86h9/For%20drrai66.pbix?dl=0
Regards,
Jimmy Tao
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 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |