Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
How can a create a new column by multiplying values from other column.
My tables look like below. How do I get reqd column? Kindly help.
month | value | qty | reqd |
jan | 2 | 1 | value * qty |
feb | 3 | 2 | value * qty |
mar | 5 | 3 | value * qty |
Solved! Go to Solution.
new column
reqd = [value] *[Qty]
reqd = sumx(Table,[value] *[Qty])
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
new column
reqd = [value] *[Qty]
reqd = sumx(Table,[value] *[Qty])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.