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 Guys,
I have 2 tables (Orders,Sales) which both has common field OrderID,
i would like to Multiply Orders table Quatity field and Sales Table Amount field.
TotalSales=Orders.Quantity*Sales.Amount
this Caliculated field i want to add in Sales table.
Can some one guide me Formulae,im new to DAX.
Solved! Go to Solution.
Hi there!
First you need to create a relatonship. Go to Modelling tab, Manage Relationships. Create new one and choose OrderID field.
Then you create a new column, and write something like this:
TotalSales = Sales[Amount]*RELATEDTABLE(Orders; Orders[Quantity])
Should work out, maybe even without a relatedtable thingy.
Hi there!
First you need to create a relatonship. Go to Modelling tab, Manage Relationships. Create new one and choose OrderID field.
Then you create a new column, and write something like this:
TotalSales = Sales[Amount]*RELATEDTABLE(Orders; Orders[Quantity])
Should work out, maybe even without a relatedtable thingy.
it worked as below.
TotalSales = Sales[Amount]*RELATED(Orders[Quantity])
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |